Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hey guys,
I am new to Power BI and I am doing a Get Data (Web) request to pull data back from an API. I am not sure how to get all of the data into my table.
The API is designed to return only a limited number of results (50 rows at a time) and they specify in their API documentation that they use paging to send their data by providing a href URL for the next set of data.
This means that for me to receive all of the data, I need to provide the href URL sent back by the API in a new GET request and repeat that process until I pull all of the data back.
I need help setting up looping in the Advanced Editor to do the initial request and then request each of the URLs sent back from the API until I have reached the end of the data.
For each request sent there is a URL sent back with the rows of data from the request. Any ideas for this newbie?
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)
Here's a good primer on API paging. Handling paging for Power Query connectors - Power Query | Microsoft Learn