Number.Random Function of Power Query
The Number.Random function in Power Query returns a random number between 0 and 1.
Syntax
 Number.Random() as number 
Example: Get a random number between 0 and 1.
Power Query M
let
    Source = Number.Random()
in
    Source       The output of the above code is:
0.919303