Refresh Power BI using company scheduler

[MonsterSky]

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

[MonsterSky]

Perfect, thank you for all the detailed information.

[MonsterSky]

No one? I have to assume that external schedulations are no possible. Am I right? Thank you.

[d_gosbell · Accepted solution]

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