Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Happy Wednesday. I have the following code which calls a function that gets API results. All works just fine as long as there's more than one loop needed (so > 500 records). I'd love to know what I'm doing wrong (and how I might write this better). I've used this for several different APIs with success - this is the only one that is giving me issues.
let
Source = (wfReportId as text, optional aftCursor as text) => let Source =
List.Generate(() =>
[
Result = try fnGetComplianceFW(wfReportId, aftCursor) otherwise null
, afterCursor = Result[data][policyAssessments][pageInfo][endCursor]
]
, each [Result][data][policyAssessments][pageInfo][hasNextPage] <> false
, each [
Result = try fnGetComplianceFW(wfReportId, [afterCursor]) otherwise null
, afterCursor = Result[data][policyAssessments][pageInfo][endCursor]
]
, each [Result][data][policyAssessments][nodes]
),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
#"Converted to Table"
in
Source
Thanks in advance,
hauffa
Solved! Go to Solution.
rethink and change the exit condition
each [Result][data][policyAssessments][pageInfo][hasNextPage] <> false
Thank you. I ended up going with this. It seems to be working.
, each List.IsEmpty([Result][data][graphSearch][nodes]) = false
rethink and change the exit condition
each [Result][data][policyAssessments][pageInfo][hasNextPage] <> false
Check out the July 2025 Power BI update to learn about new features.