Forum Discussion
Rest API pagination
I try to retrieve records from a Rest API in PowerBI, but struggle to get all pages. The API supports parameters &count and &from, and naked api calls gives this what seen in screenshot. Defaul...
in your example you would fetch the first 1000 rows, then note the fullResultSize, and create a list {1000,2000,3000,4000,5000,6000,7000}. Then you would run seven more API calls, each with the "From" set acordingly. Lastly you would combine all the results of the eight API calls.