Forum Discussion
Web API not pulling all columns
Has anyone ever had issues with a paginated web API not pulling all available columns? The company providing the data/API has confirmed the data is there, and I can also see it in the front end ...
Hi AmandaMulryan ,
You can refer to these documents and check if they can help:
Handling paging for Power Query connectors - Power Query | Microsoft Docs
powerbi - Paging REST API results in Power Query - Stack Overflow
powerbi - How to get paginated data from API in Power BI - Stack Overflow
How to do Pagination on a REST API in Power Query (Part 1) - YouTube
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.