Forum Discussion
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 every 1 minute on his screen without any interaction or refreshing from his side, how can I achieve that?
Note that:
* Automatic page refreshing is not working on the report server
* Also I took a shot with the browser extension, but the security team is not approving since it is 3rd party tools.
Thank you
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>
1 Reply
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>