Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Tom__
New Member

Looping through Paginated API

Hi all,

 

im pulling in a rest API into a Datamart and I'm struggling to loop through to pull through all the records. Currently the limit to the records that pull through is 1000 rows. The dataset increases everyday so there's no set page numbers or total records. 

to access the next page of 1000 records I need to use a 'nextPageId' within the API url. This is a dynamic id and looks like 17808983540000,2390802937. This looks like it's a concatenation of 2 Columns on the 1000th row hence why it always changes.

 

is there a way I can get power query to loop through the dynamically changing nextpageids to pull through all records as one table?

1 REPLY 1
lbendlin
Super User
Super User

As you can probably appreciate it is nearly impossible to help with API queries without access to said API  (which you may not be willing to provide for understandable reasons)

 

Please provide some more details of what you have tried.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.