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.
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
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.