Forum Discussion
PowerShell to set Report Server refresh schedule
I am trying to use PowerShell to automate some of the more mundane tasks of day to day management of our Power BI Report Server using functions like Get-RsDataSource, Set-RsDataSource. However, I am struggling with setting a refresh schedule in the same way. Does anyone have any suggestions for me please?
3 Replies
I'm working on the same. It should be possible, but currently am experiencing the same issue reported here:
The errors experience were using the client generation methods documented in the following thread by StolzHerz:
https://community.powerbi.com/t5/Report-Server/Swagger-URL-for-PBI-Report-Server/td-p/295076
Further reading here:
https://docs.microsoft.com/en-us/power-bi/report-server/rest-api
https://app.swaggerhub.com/apis/microsoft-rs/PBIRS/2.0#/info
In oder to refresh the report, there must first be an existing report schedule. Once that's created, you can get the id of the Cache Plan from the report:
http://host/reports/api/v2.0/PowerBIReports(Path='{/ReportPath}')/CacheRefreshPlans
Then pass the CacheRefreshPlan id to the following "Refresh Now" API:
http://host/reports/api/v2.0/CacheRefreshPlans(bf907379-5ff9-4aec-bdba-973c98b092f2)/Model.Execute
AnonymousGday, Did you get anywhere with this? Im tring to figure out how to copy the reports (and schedules) from one PBIRS server to another. Cheers.
