topic Re: Report screen refreshing automatically in Report Server

Report screen refreshing automatically

JIblasco — Wed, 28 Oct 2020 13:23:14 GMT

Hello everyone,

I'm trying to refresh my report screen automatically without any interaction of the user. Is it possible?. I have scheduled a refreshment that takes place every minute but only works clicking the refresh button.

Thanks in advance

Re: Report screen refreshing automatically

lbendlin — Tue, 03 Nov 2020 01:57:13 GMT

Automatic page refresh in Power BI Desktop - Power BI | Microsoft Docs

Note: Only works for Direct Query data sources.

Re: Report screen refreshing automatically

DavisBI — Tue, 03 Nov 2020 06:54:07 GMT

Hi, JIblasco

lbendlin gives the official solution, that's so great, but it only work on the standard version of PBI, not on-premise PBIRS.

I have a solution, you just need to write a simple javascript code in your browser console and run it, so that the report page can schedule refresh every minute or every second (depending on your need) , you can refer to this article for detail.

setInterval(function(){document.getElementById(<input the id of refresh button>).click(); }, 5000);

Although it works for both Import and Direct Query data sources, if you use the import mode, you still need to set the schedule refresh for the data, since the page refresh is only for cache data of the page instead of the underlying dataset.

Mark this post as solution if this helps, thanks!

Re: Report screen refreshing automatically

JIblasco — Tue, 03 Nov 2020 07:52:03 GMT

Hi lbendlin ,

Thank you for your answer. As DavisBI says, your solution only works with the standard Power BI Desktop version, but I'm using Power BI Dektop for Report Server. The refresh option in this version doesn't exist.

Anyway, thanks again for yor answer.

Re: Report screen refreshing automatically

JIblasco — Tue, 03 Nov 2020 07:54:28 GMT

Hi DavisBI ,

Ok, if there is no option to refresh the report, I'll try to refresh the browser.

Thanks!!!!!!