Allow refreshing of datasets through the API. It's quite an issue for us. After I have updated my database i either have to a) wait for the scheduled refresh to execute b) go online and press refresh on every dataset manully Would save a lot of time if i could call the API to do the refresh after i have updated my data
6 Comments
- Hey! You can refresh from the API. This is basically what's needed in PowerShell: $uri2 = "https://api.powerbi.com/v1.0/$groupsPath/datasets/$($dataset.id)/refreshes" Invoke-RestMethod -Uri $uri2 -Headers $authHeader -Method POST You'll need to build the auth first but I've got a blog post on that in the works. I will post a link here for you if needed
- '@Craig Porteous: I have built a PowerShell based solution on this , but even when the POST call for REST API is successful, some of my published datasets still show a refresh failure. Can we collaborate on this ?
- Isn't this done? https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/ However, it really would be much better if we could define schedules via the API
- 'Not sure why this is still open. We should close this one, get the votes back, and then we can vote for fixes to the refresh API implementation. thanks -e
- The requested API endpoint already exists. This idea should be closed.
- Status added:Needs Votes
