cancel
Showing results for 
Search instead for 
Did you mean: 
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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!