Accessing Fabric Capacity Metrics Semantic Model

Hi hutchamy ,

I recently ran into the exact same challenge in a multi-team environment sharing the same Fabric capacity 😅.

The semantic model behind the Microsoft Fabric Capacity Metrics App is indeed locked down by design : Microsoft hides part of the internal calculations/measures, and the model itself is not editable.

So the limitations you're seeing are actually expected, especially for some global measures like Dynamic % Base Capacity, which are calculated at the capacity scope and therefore don’t filter cleanly by workspace.

What generally works best :

• Custom Power BI report using Live Connection
You can create a new report connected to the existing dataset and apply workspace/team filters at the reporting layer.
This works well for simple showback scenarios, although some measures will still remain non-filterable because of their internal DAX logic.

• Rebuilding a custom Fabric FinOps model
This is usually the most robust long-term approach.
Instead of relying entirely on Microsoft’s semantic model, you can collect metrics through Fabric Admin APIs / Capacity APIs and rebuild your own semantic model with :

• Workspace → team mapping
• CU allocation tracking
• Capacity overage analysis
• Historical trends
• Custom chargeback/showback logic

That gives you far more flexibility for team-specific dashboards and governance.

• Custom measures
Even with Live Connection, you can sometimes add local report measures to work around a few limitations, but this remains constrained as long as the core Microsoft measures are hidden.

Unfortunately, to my knowledge, there is currently no officially supported way to unlock or inspect the internal formulas/measures of the Microsoft semantic model.

I’d also recommend checking the official Metrics App and Capacity APIs documentation if you decide to move

toward a more custom governance/showback architecture.

Docs : 

• https://learn.microsoft.com/fr-fr/fabric/enterprise/metrics-app 
• https://learn.microsoft.com/en-us/rest/api/fabric/articles/ 
• https://learn.microsoft.com/en-us/rest/api/fabric/core/capacities/list-capacities