How to Change the AutoRefresh Time on a SQL Server Reporting Services (SSRS) Report

This question comes up from time to time, “I have a dashboard report and I want it to refresh automatically every two minutes. How can I do this?” Or worse yet, there is a misconception that SSRS reports can’t be used to create dashboards because they don’t auto-refresh.

The first time I was asked this question I thought that you could update the refresh time from the manage properties option for an individual report. This, however, turns out to be incorrect, even in SQL Server 2016.

How do you set the AutoRefresh time?

Start by opening the report in your preferred SSRS tool (SQL Server Data Tools (SSDT-BI), SQL Server Business Intelligence Development Studio (BIDS) or Report Builder (RB)). In my case, I’m using SSDT-BI.

How to Change the AutoRefresh Time on a SQL Server Reporting Services (SSRS) Report-SSDT-BI 

In the Properties window, ensure that Report is selected.

How to Change the AutoRefresh Time on a SQL Server Reporting Services (SSRS) Report-Report

Under the Misc section select the AutoRefresh row.

How to Change the AutoRefresh Time on a SQL Server Reporting Services (SSRS) Report-AutoRefresh

Change the AutoRefresh to 120 seconds (two minutes). The default is 0 seconds, which means never refresh the results.

How to Change the AutoRefresh Time on a SQL Server Reporting Services (SSRS) Report-120 Seconds

From this point, you would save the report and upload it to your SSRS site as you would any other report.

If you have any questions, please feel free to contact me at @GarthMJ.

Showing 4 comments
  • a9860367
    Reply

    This means that refreshing the page or even the use of control and date range filters doesn’t refresh the data for static source types.

  • hafid
    Reply

    If the refresh functionality doesn’t work for you have the option of direct query, which connects directly to your data source each time the report is executed.

  • tiran
    Reply

    Can autorefresh function still work after I publish (export) a report from SQL server report builder?

    • Garth Jones (Admin)
      Reply

      Yes, it will still work after you publish the report with report builder.

Leave a Comment

Share via
Copy link
Powered by Social Snap