Auto Refresh On Premise reports on the Report Server

[johndha]

Hello,

I am looking for a different methods to auto refresh reports, these reports are on Premise hosted on Power BI Report Server.

Thanks

[schueppi]

I tried New-RsRestCacheRefreshPlan but the 'Internal Server' returns 500 error. I use Power BI Reporting Server with a import model. Data are imported from a MS SQL Server 2014 Express Edition without SQL Server Agent. Are there any other conditions that New-RsRestCacheRefreshPlan works properly?

[v-henryk-mstf]

Hi @johndha ,

For your description, I think you can use the following PowerShell functions to refresh the powerbi report hosted on the powerbi report server.

1. Get-RsRestCacheRefreshPlan
2. New-RsRestCacheRefreshPlan
3. Start-RsRestCacheRefreshPlan

This allows you to create (new), get and start cache refresh schedules for Power BI reports deployed to PBIRS instances. For clarity, these only apply to reports that use the import model and not to reports that use direct queries.

Depending on your application scenario, refer to the following links for details.

GitHub - microsoft/ReportingServicesTools: Reporting Services Powershell Tools

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PARAS121]

Hi Henry,
How can we setup hourly refresh plan on PBI report server using 'New-RsRestCacheRefreshPlan' function in Powershell

[d_gosbell]

There are not a lot of options in this area. But it depends on what problem you are trying to solve or what errors you are getting as to what the possible solutions or workarounds might be. Can you give us more details on the problem you are trying to solve?