Forum Discussion
Usage Data Won't Refresh
- 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
Hi dcohare
Welcome to the Microsoft Fabric Community.
Below are the steps that might resolve your issue.
- Check data source credentials → Go to Workspace > Usage metrics report dataset > settings > data source credentials, update and save.
- Manually refresh the dataset → Click Refresh Now, then check Refresh History for errors.
- Verify report connection → Open the report, go to transform data > data source settings, ensure it’s linked correctly.
- Clear query cache → In report settings, clear cache and refresh again.
- Republish → If issues persist, try ro republish from Power BI Desktop
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks
Cheri Srikanth
Community Support Team