Forum Discussion
Refresh Power BI using company scheduler
Hello Community, I'm new on this forum and I hope I have chosen the right section to write this post.
I need to schedule the refresh of some Power BI report using an external scheduler because I need to keep all the schedules of our systems inside our company scheduler.
Is there a command line way to submit a report refresh? Is this way I will able to submit that command using our company scheduler that is able to send a command line to a server.
Thank you.
Andrea
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
3 Replies
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
Perfect, thank you for all the detailed information.
