Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
PowerShell
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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-code-generated-fr.html

 

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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    cnschulz
    Helper IV
    6 years ago

    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.