Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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?
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
7 | |
6 |