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
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!
Thanks
Cheri Srikanth
I didn't accept as a solution because I can't delete the entire report and recreate it. The other solutions haven't worked. Thanks!