Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Data Days Monthly is back. Join us on March 26th for two expert-led sessions on 1) Getting Started with Fabric IQ and 2) Mapping & Spacial Analytics in Fabric. Register now

Dataset Refresh from API

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
Status: Needs Votes
Comments
fbcideas_migusr
New Member
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
nitinsapru
New Member
'@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 ?
graeme
New Member
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
ensyder
New Member
'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
bertrand_d-arbo
New Member
The requested API endpoint already exists. This idea should be closed.
fbcideas_migusr
New Member
Status changed to: Needs Votes