Forum Discussion
Fabric Capacity metrics data REST API or alternate ways to pull it
I have quite a few activities going on on Power BI. I have admin access and want to be able to pull in information like CPU usage, usage spike with respect to time etc. I came across an inbuilt app t...
If you are familiar with the execute queries REST API you van retrieve the data you want with DAX https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries
Thanks for your reply Amira
However, I saw that this approach has limitations of 1million data items.
Is there any other method that does nto have such limitations?
If your dataset is large, consider using paginated reports. In this case yoy can automate getting data of REST API endpoints related to reports and exports.
I can't see any other alternative.Could you please share links to how I can paginate reports in api?
I don't quite understand what paginated reports are so if you could briefly describe how it is done in this context that would be very helpful.