Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
john_elmasry
Frequent Visitor

Auto Refresh in Power BI Report Server

‎07-26-2023 10:10 PM

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

Message 1 of 2
837 Views
0
1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User

‎07-27-2023 10:15 PM
@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=Autom... 

 

@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>

 

View solution in original post

Message 2 of 2
798 Views
1 REPLY 1
d_gosbell
Super User
Super User

‎07-27-2023 10:15 PM
@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=Autom... 

 

@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>

 

Message 2 of 2
799 Views

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All
Top Solution Authors
View All