Forum Discussion

Thilbetr's avatar
Thilbetr
Frequent Visitor
4 years ago

Paginated, Throttled, Parameterized API Data Sourcing

Good afternoon,   Pooling our awesome community here for thoughts on approach.  I am currently sourcing data from an API endpoint using Power Query on PowerBI Desktop. The API isn't the most ide...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Thilbetr ,

 

Maybe you could try using the $Skip ODATA expression to do pagination In Power Query.

 

For more information, please refer to:

https://www.reddit.com/r/PowerBI/comments/gwikkb/best_way_to_run_multiple_paginated_api_calls_in_a/ 

How To Do Pagination In Power Query 

https://community.powerbi.com/t5/Desktop/JSON-Joining-Records-in-Groups/td-p/327823 

Creating a loop for fetching paginated data from a REST API 

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.