Extracting data from fabric capacity metrics app

[MonicaCVL]

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:

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

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

[amitchandak]

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

[MonicaCVL]

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]

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

[MonicaCVL]

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.