Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Extracting data from fabric capacity metrics app

We have a capacity metrics app created.Trying to fetch the data from semantic model  using the following code:


import sempy.fabric as fabric

df_table = fabric.read_table("Fabric Capacity Metrics", "Billing type")
since it is a template app or what I am not sure I keep getting workspace not found as shown below:


Is there any other way to fetch the data from semantic model tables?

or may be fetch the data from a report table visual!?

Super User
Super User

@MonicaCVL , Make sure you have imported Sempy before this

Semantic Link in Microsoft Fabric:


Make sure lakehouse is selected on the left


Syntax seem correct to me.

Thank you for the response! but it is working fine with all the semantic models. But the semantic model which I am trying to access is fabric capacity metrics app, this is where I am getting this error workspace not found! any solution for this!?


Solution Sage
Solution Sage

@MonicaCVL  have you tried Purview Hub dataset from Admin monitoring workspace?

Thanks for the response! No I didn't as I don't have admin level access at the Fabric tenant level! Here I am trying to get the data from fabric capacity metrics app. 

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.