Forum Discussion
Solved
REST API pull with pagination
I'm fairly new using APIs for building a Power BI report. I'm sure there is an easy way to do this, but I don't know how to proceed. I have a single pull from a REST API. Each page in the res...
Hi paulmorgan,
You can take a look at the following document about the help functions about processing pagination api if it meet your requirement:
Helper Functions#tablegeneratebypage
Regards,
Xiaoxin Sheng
Use a recursive function
getdata(offset,count)
Then inside that function do your API call. If the result (returned rows) is the same as the count, increase the offset by one and call the function again. If it is less, pack up, and return the collected rows back to the calling process.
Thank you for taking the time to respond.
I'm not that familiar with how to do what you suggest.
However, I will send this suggestion to someone in our development team and ask for assistance on how to implement.
Thanks again
