Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am looking for a different methods to auto refresh reports, these reports are on Premise hosted on Power BI Report Server.
Thanks
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?
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.
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.
Hi Henry,
How can we setup hourly refresh plan on PBI report server using 'New-RsRestCacheRefreshPlan' function in Powershell
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?