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 that has an inbuilt dataset that creates such graphics. It was Fabric Capacity Usage metrics. Now I want pull this data supporting these visuals and periodically save it in an object storage solution. Is there a REST API available to pull in this data from the Fabric Usage Capacity Metrics app? If such an API is not available, what are some ways by which I can pull this data in python?
4 Replies
- AmiraBedh
Super User
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?
- AmiraBedh
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.
