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
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.
