Forum Discussion
Sachintha
Helper III
Helper IIIFunction 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...
lbendlin
Super User
Super UserShow what
fnIteratePSTsdoes.
SachinthaHelper III
Helper IIIApologies, 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- lbendlin
This will only hurt a little: Power Query M Primer (Part 13): Tables—Table Think II | Ben Gribaudo
- Sachintha
Are you referring to 'disable parallel loading' as a fix? I tried it, which makes the refresh time much longer (over 2 hours), but even then it eventually failed. Same error as before.
- lbendlin
No, I am referring to the "everything in different partitions" vs "everything in the same partition" advice. Your indicated problem was the reference to other queries, not the performance.