topic Re: Refresh Power BI using company scheduler in Report Server

Refresh Power BI using company scheduler

MonsterSky — Mon, 23 Mar 2020 13:28:19 GMT

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

Re: Refresh Power BI using company scheduler

MonsterSky — Wed, 01 Apr 2020 13:39:52 GMT

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

Re: Refresh Power BI using company scheduler

d_gosbell — Thu, 02 Apr 2020 23:30:06 GMT

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

Re: Refresh Power BI using company scheduler

MonsterSky — Fri, 03 Apr 2020 12:50:27 GMT

Perfect, thank you for all the detailed information.