Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I would like to create a list of numbers but the number of rows will depend on a function that calls and API and returns the number of rows I have tried.
= List.Numbers(0,Function.Invoke( fnDealsIterations()),100)
the function has no variables and just returns a number 4 at the moment,
is this possible?
thanks
Solved! Go to Solution.
Hi @jasemilly ,
Create a function as below:
let
Source =()=>let
Source= 4
in
Source
in
Source
Then create a query as below:
let
Source = List.Numbers(0,#"Invoked Function",100)
in
Source
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @jasemilly ,
Create a function as below:
let
Source =()=>let
Source= 4
in
Source
in
Source
Then create a query as below:
let
Source = List.Numbers(0,#"Invoked Function",100)
in
Source
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @jasemilly
As long as the function retunr the data type required as second argument of List.Numbers it should certainly be possible. Have you tried it? I do not think you need the Function.Invoke
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |