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.
Hi,
I have a List.Generate that returns list rows of 1000 records from a API call. At this moment there is 22082 records in the source table and I want the list generation to stop when all records are received. In this case there should be 23 rows, with only 82 records in the last row. When harcoding it to stop after 24000 records I get a row with null. How can I make this loop to stop when the row is null?
Solved! Go to Solution.
Hi @Dagobert
On line 4, change
each [cursor_position] <= 24000
to
each [WO_list] <> null
This is the loop-continuation condition for List.Generate.
Does this work at your end?
Yes, it works fine, so easy!
Thanks a lot
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.
User | Count |
---|---|
99 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
105 | |
86 | |
72 |