Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
HI all!
I get data from api, but get only 50 rows.
Total in api 650 rows.
How get all data from api? It need using offset every 50 row like ?offset=50,?offset=1000 etc
Thank you advanced
Hi @aignn ,
Basically you can use &top to get data from web api, like this:
https://api.applicationinsights.io/v1/apps/DEMO_APP/events/customEvents?$top=1000
Here is the document introduces it in details that you can refer:
Analyze recent requests using the Events API
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @aignn.,
Could you please provide an example you want to follow?
Perhaps a parameter would be helpful in this.
1. You create a parameter in Power Query.
2. You set the default value = 50 .
3. You add a parameter to the query, in which you retrieve the data using the API, as a filter, eg for the index.
_______________
If I helped, please accept the solution and give kudos! 😀
@aignn , refer if this can help
API pagination
http://sqlcodespace.blogspot.com/2017/09/power-bipower-query-api-response.html
https://datachant.com/2016/06/27/cursor-based-pagination-power-query/
https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |