Extracting data from fabric capacity metrics app

Question

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

johnbasha33 · Answer

Anonymous&nbsp; have you tried Purview Hub dataset from Admin monitoring workspace?

amitchandak · Answer

Anonymous , Make sure you have imported Sempy before this 
Semantic Link in Microsoft Fabric: https://youtu.be/OIE26E2H5RI
&nbsp;
Make sure lakehouse is selected on the left
&nbsp;
Syntax seem correct to me.
https://learn.microsoft.com/en-us/python/api/semantic-link-sempy/sempy.fabric?view=semantic-link-python#sempy-fabric-read-table

anonymous · Answer

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

anonymous · Answer

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.&nbsp;

purpleomega · Answer

Were you able to get the data?

Forum Discussion

Extracting data from fabric capacity metrics app

5 Replies

Related content

Fabric Capacity Metrics

Power BI - Fabric Capacity Metrics

Fabric Capacity Metrics discrepencies ?

Fabric Capacity Metrics Time point

Fabric capacity metrics - Timepoint Detail