Forum Discussion

Sachintha's avatar
Sachintha
Icon for Helper III rankHelper III
2 years ago

Function within Function and Scheduled Refresh from PowerBI Service

I have access to an API that lets me retrieve results of tests undertaken by my company employees. Each month, employees get one or more tests. The total set of tests all employees get in a month are...
Need Help
Show and Tell
Tips and Tricks
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Show what 

fnIteratePSTs

does.

  • Sachintha's avatar
    Sachintha
    Icon for Helper III rankHelper III
    2 years ago

    Apologies, it was mislabled in the post. This is the function:

     

    fnIteratePSTs = (PstId as text) =>
let
    Source = List.Generate(
        ()=> [ Offset = 1, Results = fnGetTestResults(PstId, 100, 1) ], 
            each not (List.IsEmpty([ Results ])), 
            each [ Results = fnGetTestResults(PstId, 100, [Offset] + 1 ), Offset =  [Offset] + 1 ], 
            each [Results]
        )
in
    Source