Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |