Forum Discussion
How to pull data from API that returns only 50 rows at a time.
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 on...
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