Forum Discussion

dcohare's avatar
dcohare
Helper I
1 year ago
Solved

Usage Data Won't Refresh

Hi -    I am trying to get the Usage Data Metrics for one of my reports. We haven't refreshed the usage metrics since September 2024 and yesterday, we tried to refresh. Got the error that the crede...
  • v-csrikanth's avatar
    1 year ago

    Hi dcohare 

    Sorry the late response and inconvenience caused.

    If you prefer not to delete the dataset, you can trigger a refresh using the Power BI REST API.

     

    Please follow the below steps to refresh using the API.

    • Register an App in Azure AD. 
    • Get Workspace & Dataset ID from service.
    • Trigger Refresh using below PowerShell.

    ******************************************************** 

     $clientId = "YOUR_CLIENT_ID"

    $clientSecret = "YOUR_CLIENT_SECRET"

    $tenantId = "YOUR_TENANT_ID"

    $workspaceId = "YOUR_WORKSPACE_ID"

    $datasetId = "YOUR_DATASET_ID"

     

    # Get Access Token

    $tokenUri = "https://login.microsoftonline.com/$tenantId/oauth2/token"

    $body = @{

    grant_type = "client_credentials"

    client_id = $clientId

    client_secret = $clientSecret

    resource = "https://graph.microsoft.com"

    }

    $tokenResponse = Invoke-RestMethod -Uri $tokenUri -Method Post -Body $body

    $accessToken = $tokenResponse.access_token

     

    # Trigger Dataset Refresh

    $headers = @{ Authorization = "Bearer $accessToken"; "Content-Type" = "application/json" }

    $uri = "https://api.powerbi.com/v1.0/myorg/groups/$workspaceId/datasets/$datasetId/refreshes"

    $response = Invoke-RestMethod -Uri $uri -Headers $headers -Method Post

    Write-Output "Refresh Triggered"

    *******************************************************

    • Go to Power BI Service → dataset settings and refresh

     

    If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.

    Best Regards,
    Community Support Team _ C Srikanth