Forum Discussion
Combine Rest API Pagination and Multiple Loops
I have tried list. generate finction but it does not provide values. Also I have watched the tales from front video but it requires count of the API rows which i don't have.
You can use List.Generate to peek into the response and see if at a given offset no more data is returned.
You could also use recursive functions but these generally do not work well when you have to return a lot of data.
As you may imagine - without access to your API it is very difficult to help you with the code. That's a problem for any scenario that requires authentication/authorization. Pity that they don't have dummy/test user accounts.
Hi lbendlin
PFB the summarized issue in the below link,
It has a video link through which you will be easily able to explain the the issue and provide solution.
https://community.powerbi.com/t5/Developer/Power-BI-Pagination-amp-Looping-using-List-Generate/m-p/2383290
Best,
Saad.