Report screen refreshing automatically

[JIblasco]

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

[DavisBI · Accepted solution]

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!

[JIblasco]

Hi @DavisBI ,

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

Thanks!!!!!!

[lbendlin]

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

Note: Only works for Direct Query data sources.

[JIblasco]

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.