Forum Discussion
Multiple scripted queries to API
Hi All, Noob PowerBI user here..
I have a web hosted API to query collect some measurements. I can get to query to return data, but the API has some limitations. It will only allow 1000 values per page, and if the data exceeds this will insert a field with a query to get the next page with 1000 values and so on.
Can I set a script to send the initial query, get the data, then keep sending depending on whether the next query is present in the returned data ?
I may be using incorrect terminology, but if its a "can do" and there is an example / guide somewhere would be appreciated.
Search for "Power BI API Paging"
Handling paging for Power Query connectors - Power Query | Microsoft Learn
3 Replies
- lbendlinSuper User
Search for "Power BI API Paging"
Handling paging for Power Query connectors - Power Query | Microsoft Learn
- LemmingNew Member
Thanks for the pointer. Reading the description, exactly what i need.. Unfortunately, the helper assumes you know something about M language lol.. More reading / googling for me..
- LemmingNew Member
Will do, thanks foirthe help