Forum Discussion

Padmanabhan's avatar
Padmanabhan
Icon for Helper II rankHelper 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 on...
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.
Anusha66's avatar
Anusha66
Icon for Advocate IV rankAdvocate 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.