< Blog

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

By Garth Jones

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.