Table of contents
With the introduction of Fabric Capacities it is crucial for a Fabric Admin to monitor the workload and CU consumptions across the tenant.
The Fabric Capacity Metrics App is an excellent tool for gaining insights of all fabric items and users spread across your capacities.
Installing the App is simple you can follow this Microsoft Document to get it installed !
Current Limitations:
Though you can view / edit the report and semantic model in your Microsoft Fabric Capacity Metrics App in service, you won’t be able to download either one of them. But why ? 🤔
Because as part of the template package the report or semantic model can’t be downloaded stating "Download .pbix is denied in template app datasets"
Workaround:
The only thing which is stopping us from downloading the pbix is the template app workspace.
Can we migrate the contents to a new workspace and download the file from there? The answer is YES !. Will show you how..
Prerequisites:
The Microsoft Fabric Capacity Metrics App must be installed and hosted on a Premium or Fabric Capacity.
Tabular Editor 2.x: Download
Read / Write permissions enabled under Capacity Settings → Power BI Workloads → XMLA Endpoint.
Permissions to call Report Rebind API
Let's get started:
Step 1: Connect to the Model using Tabular Editor.
Navigate to the Fabric Capacity Metrics Semantic Model Settings and copy the server connection string.
If the server settings are not visible, switch the workspace from Pro to Premium/Fabric and try again.
- Now, head over to Tabular Editor and navigate to File -> Open -> From DB
- Paste the Server string and sign in using your credentials.
- Select Fabric Capacity Metrics and click OK
- Then go to File -> Save as and Save the bim file in your preferred location.
Step 2: Deploy the Model to another premium workspace.
Since we have extracted the bim file, we can deploy a cloned version of our capacity metrics in a different workspace, in my case, the Deployment workspace.
Navigate to the Deployment workspace and copy the connection string under License info.
Return to Tabular editor and click Model -> Deploy or press f6 to deploy the model.
Copy paste the workspace connection string of Deployment workspace.
Click Next and give your semantic model a name. I have kept as "Fabric Capacity Metrics - Clone"
- Then Next -> Next -> Deploy. Took me around 30 secs to deploy the model.
- Refresh the workspace to find your cloned model and refresh it.
- This model is downloadable. However, you will not be able to retrieve any data when viewing it on the desktop, as it utilizes a customized connection that functions exclusively on the service.
Step 3: Clone the Fabric Capacity Metrics report to Deployment workspace
- Navigate to Fabric Capacity Metrics App workspace and clone the report to the Deployment workspace using the Save a copy
- I have named the report as "Fabric Capacity Metrics Report - Clone". If prompted choose a Sensitivity label and Save.
Step 4: Reports - Rebind API magic
Though we have both the cloned report and model in our Development Workspace. Still we cannot download the Report. Why ?🤔
Because the report clone is still tied to our template app dataset.
We will use the Reports - Rebind API to repoint the cloned report to our cloned model.
Hit the Try It option in the documentation and sign in.
- Get the groupId, reportId and datasetId from the report/dataset URL in your Development Workspace.
- Click Run to rebind the report. Response Code 200 confirms that the rebind was successful.
- Again Save a copy of your cloned report into your Development Workspace. This time I am keeping the name as "Fabric Capacity Metrics Report - New".
- Now the download option is enabled for the New Report which we just created.
Note: Save a copy of the report from the report view pane to enable the download option and not from settings view.
Download PBIT from my GitHub: