Invoke function inside a list?

[jasemilly]

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

[v-kelly-msft · Accepted 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!

[AlB]

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.