Fabric Capacity metrics data REST API or alternate ways to pull it

[ameya1]

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?

[AmiraBedh]

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

[ameya1]

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.

[ameya1]

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.