Skip to main content
cancel
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

Reply
MonicaCVL
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")
df_table
 
since it is a template app or what I am not sure I keep getting workspace not found as shown below:
MonicaCVL_0-1715674077481.png

 

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

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

 
4 REPLIES 4
amitchandak
Super User
Super User

@MonicaCVL , Make sure you have imported Sempy before this

Semantic Link in Microsoft Fabric: https://youtu.be/OIE26E2H5RI

 

Make sure lakehouse is selected on the left

 

Syntax seem correct to me.

https://learn.microsoft.com/en-us/python/api/semantic-link-sempy/sempy.fabric?view=semantic-link-pyt...

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!?

 

johnbasha33
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

Announcements
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.