PowerShell to set Report Server refresh schedule

[Anonymous]

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?

[Anonymous]

I'm working on the same.  It should be possible, but currently am experiencing the same issue reported here:

https://developercommunity.visualstudio.com/content/problem/760124/reporting-services-2017-rest-api-...

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

[Anonymous]

Hi Karl

Thanks for this, really useful information.  Slightly different issue for me, I am just trying to create a new refresh schedule where one does not exist yet.  Not had time to check out all the references you very kindly quoted, but will get to that later this week.

Thanks again.

[cnschulz]

@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.