Forum Discussion
Refresh Power BI using company scheduler
This is possible, but it would be a two step process, so you'd need to write a script using something like Powershell or Python that can call a REST API.
The first thing you'd need to do is to setup a scheduled refresh on your report, but you can set this up for a once off date some time in the past so that it does not actually get triggered.
Then you would use the following GET request to get a list of the refresh schedules
https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0#/PowerBIReports/GetPowerBICacheRefreshPlans
Then you would use the ID of the first refresh plan and use POST request to the model.execute endpoint to trigger the refresh immediately
https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0#/CacheRefreshPlans/ExecuteCacheRefreshPlan
No one? I have to assume that external schedulations are no possible. Am I right? Thank you.
This is possible, but it would be a two step process, so you'd need to write a script using something like Powershell or Python that can call a REST API.
The first thing you'd need to do is to setup a scheduled refresh on your report, but you can set this up for a once off date some time in the past so that it does not actually get triggered.
Then you would use the following GET request to get a list of the refresh schedules
https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0#/PowerBIReports/GetPowerBICacheRefreshPlans
Then you would use the ID of the first refresh plan and use POST request to the model.execute endpoint to trigger the refresh immediately
https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0#/CacheRefreshPlans/ExecuteCacheRefreshPlan