Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 3
Anonymous
Not applicable

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
Not applicable

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.

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.