Forum Discussion
Advocate IHow to Download the Fabric Capacity Metrics Data
I found these ressources :
Tags are key-value pairs that you can apply to resources, resource groups, and subscriptions. https://learn.microsoft.com/en-us/azure/azure-resource-manager/management/tag-resources?tabs=json explains how to add and manage these tags.
For API pulls related to Power BI usage (including users and CUs), the Power BI REST APIs provide endpoints for retrieving detailed usage metrics:
- The Power BI Admin APIs https://learn.microsoft.com/en-us/rest/api/power-bi/adminallow you to pull user activity reports and track capacity metrics, such as Capacity Unit consumption.
- For querying specific dataset usage or capacity, you can use the Execute Queries API https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/execute-queries
Microsoft EmployeeI have developed a comprehensive blog post that demonstrates how to extract Fabric Capacity Metrics data from a semantic model and incrementally load it into Fabric DW. This solution employs a Spark notebook for orchestration, ensuring efficient and incremental data loading: Fabric Capacity Metrics Extraction | fabricpocmain.github.io
Hi! This solution looks a lot less complicated than the method involving a lot of DAX put together on the pbi-guy website. However the dataframe returned by
fabric.read_table("Fabric Capacity Metrics", "MetricsByItemandDay")... and any other Metrics* table is empty for us. My colleague has experimented with the pbi-guy DAX method and apparently that also returns zero results until you pass capacity ID and timepoint parameters. Is something similar going on here?
- azurepocmain
Hi kayl-669,
I've updated the instructions to specifically include the workspace and dataset IDs rather than just passing variables. Additionally, I utilized the remote parameters, however, the Capacity Metrics workspace still requires capacity, or an exception will be thrown. I hope this resolves the issue. Please keep me posted. Fabric Capacity Metrics Extraction | fabricpocmain.github.io