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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
TheSimpleConstr
Regular Visitor

How to use a value in a query as a looping query

I'm trying to use the data from an API of an application we use to manage construction projects.

 

The query only returns the first 100 rows and a link to the next page.

TheSimpleConstr_0-1720767612305.png

 

TheSimpleConstr_1-1720708085332.png

It keeps returning the next page until the last page, then the link stays the same.

TheSimpleConstr_2-1720708107244.png

 

Is there a way to use these links and put these all in one query so i can use all of the data?

The 'bookmark numbers' arent incemental.

 

Thanks in advance! 

2 REPLIES 2
TheSimpleConstr
Regular Visitor

@lbendlin Thanks for your reply, i found these functions and pages when i've been working on it for the last 2 days.

I am very inexpirienced in these things , so i havent had any luck.

 

In the provided links there are these questions:

  1. How do you request the next page of data? --> Its in a column in the return of the 'first' query
  2. Does the paging mechanism involve calculating values, or do you extract the URL for the next page from the response? --> We extract the URL as a value (the complete URL)
  3. How do you know when to stop paging? --> When the 'currect' URL equals the 'next' URL
  4. Are there parameters related to paging (such as "page size") that you should be aware of? --> Don't think so, the query returns 100 values of data.

What is a next step for me? 
I am very much willing to try, right now i'm just a little bit lost!

lbendlin
Super User
Super User

Please check the convenience function here

 

https://learn.microsoft.com/en-us/power-query/handling-paging

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

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.

Top Solution Authors