'POWERQUERY : Iterate on a source n times because of a limit
I need to gather elements calling an API with protocol http. I am able to get the result, but the API can't return more than 100 results at each call
For this exemple, here is my step where we can see that I could have 3837 elements (total_count) but only 100 elements are returned (limit). The offset can be use to start at a different element of the 3837 elements Notice that I can force the limit, but I can't have a value bigger than 100
Finaly, I would like to have a loop that can call x times the http (39 times for this exemple) by increasing each time the offset and reconciliate the 39 results in one table
Would you have some tips to help me with this problem ? Can we do some kind of loop ?
Thanks in advance
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|

