How to pull data from API that returns only 50 row...

Zack_Christie · ‎09-27-2023

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?

lbendlin · ‎10-02-2023

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