Fabric metric extraction using rest api

[Padmanabhan]

I extracted the needed metrics of fabric using the powerBI rest API.

"https://api.powerbi.com/v1.0/myorg/groups/{workspace_id}/datasets/{dataset_id}/executeQueries"

But the data is extracted only when the fabric capacity is in resume state. If it is paused the fabric metrics are not get extracted.

Whether we can extract the metrics when the fabric capacity is off ?
Any other ways to extract the metrics when it is paused?

[Anusha66 · Accepted solution]

I'd suggest - 

Resume the capacity via API just before pulling metrics (then pause again). Use the Azure Fabric Capacities REST API: POST .../providers/Microsoft.Fabric/capacities/{capacityName}/resume and .../suspend for pause; automate with Logic Apps/Runbooks.
then turn it off.

[Padmanabhan]

Hi,

I am doing a cost optimization recommendation, for that i need to extract the cu consumption metrics.
And i am extracting it through a power BI rest API .
And also i am using a batch scheduler to extract metrics for all services . In that case when fabric is paused this task flow is failing.

[tayloramy]

Hi @Padmanabhan, 

In order to get the capacity utilization metrics, the capacity needs to be active. I think both capacity metrics and the capacity utilization events in RTH require the capacity to be active, not suspended. 

I don't think you can do this without enabling the capacity. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

[tayloramy]

Hi @Padmanabhan, 

I don't believe there is any way to get metrics/metadata while the capacity is paused. 

More details about what you're trying to do and the intended goal would be helpful. 

 If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[AntoineW]

Hi,

The App Metrics retrieve metadata from the fabric capacity like CU consumption, items CU, ...

So if the Fabric capacity is paused, the metrics app will not get any metadata too. 

What is your use case to better understand your need ?