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
Super Userwhat are your requirements ? Can you clarify more what you want to achieve ?
Advocate II need to create a report on both cost and usage pertaining to PBI. I currently have a PBI report built off of the Azure cost metrics data. I want to add to that usage data (particularly around users and CUs) per capacity and workspace.
It would be great if I could also tie cost data to a workspace. That would help with chargeback costs for specific projects.
- AmiraBedh
Use Azure cost data to track expenses by tagging resources or workspaces, and the Power BI Admin or Capacity Metrics APIs to pull user activity and CU usage per workspace. Then, correlate the cost with the workspace CU consumption using DAX in Power BI to allocate costs for chargeback reporting, providing insights into both financial and operational metrics for your organization.
- taran42
Thanks, Amira. Do you have any quick references on tagging resources/workspaces in Azure and documentation on API pulls for users/CUs?
- AmiraBedh
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