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.
Go to 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
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
View solution in original post
Perfect, thank you for all the detailed information.
No one? I have to assume that external schedulations are no possible. Am I right? Thank you.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.