Forum Discussion

Padmanabhan's avatar
Padmanabhan
Helper II
8 months ago
Solved

Fabric metric extraction using rest api

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?
capacities
one lake
workspaces
  • Anusha66's avatar
    Anusha66
    8 months ago

    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.

5 Replies

  • AntoineW's avatar
    AntoineW
    Super User
    8 months ago

    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 ? 

  • Anusha66's avatar
    Anusha66
    Advocate IV
    8 months ago

    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.
  • tayloramy's avatar
    tayloramy
    Super User
    8 months ago

    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.

  • Padmanabhan's avatar
    Padmanabhan
    Helper II
    8 months ago

    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's avatar
      tayloramy
      Super User
      8 months ago

      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.