Forum Discussion

john_elmasry's avatar
john_elmasry
Frequent Visitor
3 years ago
Solved

Auto Refresh in Power BI Report Server

Hello Everyone, I have a dashboard where it is live connected to SQL DB, Directquery Mode. I have published this to On-Prem Report Server, The business user needs to have this dashboard refreshing ...
"data refresh"
"Power BI Report Server"
Auto Refresh
AutoRefresh
Direct Query
d_gosbell's avatar
d_gosbell
Super User
3 years ago
john_elmasry wrote:

* Automatic page refreshing is not working on the report server

 

It is not designed to work on Report Server, It is a documented limitation see https://learn.microsoft.com/en-us/power-bi/report-server/compare-report-server-service#:~:text=Automatic%20page%20refresh%20for%20DirectQuery%20models 

 

john_elmasry wrote:

* Also I took a shot with the browser extension, but the security team is not approving since it is 3rd party tools.

Unfortunately browser extensions are one of the few options for the on-prem report server

 

If you have a web server where you could host a web page you could possibly use URL access (see Access Report Server Items Using URL Access - SQL Server Reporting Services (SSRS) | Microsoft Learn) to your report and use the refresh header

<html>
    <head>
        <metahttp-equiv="refresh"content="30">
    </head>
    <iframetitle="Some Report"
            style="position: absolute; height: 100%; width: 100%; border: none"
            src="https://<yourreportserer>/..."
            frameborder="0"
            allowFullScreen="true">
    </iframe>
</html>