topic Re: Auto Refresh On Premise reports on the Report Server in Report Server

Auto Refresh On Premise reports on the Report Server

Anonymous — Mon, 28 Mar 2022 06:46:41 GMT

Hello,

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

Thanks

Re: Auto Refresh On Premise reports on the Report Server

d_gosbell — Mon, 28 Mar 2022 22:36:53 GMT

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?

Re: Auto Refresh On Premise reports on the Report Server

v-henryk-mstf — Fri, 01 Apr 2022 10:10:28 GMT

Hi Anonymous ,

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

Get-RsRestCacheRefreshPlan
New-RsRestCacheRefreshPlan
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.

Re: Auto Refresh On Premise reports on the Report Server

schueppi — Tue, 05 Apr 2022 09:50:45 GMT

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?

Re: Auto Refresh On Premise reports on the Report Server

Anonymous — Tue, 04 Jul 2023 08:41:22 GMT

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