Kristers on 23 May 2017 21:31:12
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
- Comments (5)
RE: Dataset Refresh from API
The requested API endpoint already exists. This idea should be closed.
RE: Dataset Refresh from 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
RE: Dataset Refresh from API
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
RE: Dataset Refresh from API
'@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 ?
RE: Dataset Refresh from API
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