Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

API pagination next_page parameter

Hello, I need to iterate using the next_page parameter to be able to fecth all the api records joining each page in a single final table. In each call I can fecth 1000 records and I have no way of knowing in advance how many pages there are or how many records there are.
Any help will be very valuable.
Thanks in advance.



Captura de Pantalla 2021-05-16 a la(s) 11.39.56.png

Super User IV
Super User IV

Please see this video with a walkthrough of one way to do this.

Power BI - Tales From The Front - REST APIs - YouTube




Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Hi Pat, Thanks, I just saw the video, it is a good resource but it is not my case as I do not have the total_count parameter. If I had it, I could generate a list of number from 1 to (total_count / 1000) to know how many pages I need to have all the records, but it is not possible.



Community Champion
Community Champion

Hey @ioniPeis ,


check the following articles, they describe exactly your scenario:

Loop through Multiple Web Pages using Power Query - Adatis

Iterating over an unknown number of pages in Power Query - avoid endless loops - Power BI (powerbi-p...


If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Top Solution Authors