Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Solved! Go to Solution.
Search for "Power BI API Paging"
Handling paging for Power Query connectors - Power Query | Microsoft Learn
Will do, thanks foirthe help
Search for "Power BI API Paging"
Handling paging for Power Query connectors - Power Query | Microsoft Learn
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..
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
64 | |
61 | |
23 | |
17 | |
12 |