TL;DR: Power BI’s Automatic Page Refresh keeps report pages showing live data by re-querying a DirectQuery source at set intervals. Fixed Interval refreshes on a simple schedule, like every 30 minutes by default, while Change Detection re-queries only when a chosen measure’s value actually changes, such as a new customer ID appearing. Both require DirectQuery, and shorter intervals generally require a Premium or Premium Per User license.

When we are interacting with data at the decision level, it becomes critical for the dashboards to convey the latest data to the decision makers.
“You are the decision maker of a marketing company who are planning to launch a new product that is expected to be a pioneer in its segment. Here, marketing manager is heavily dependent over the results of recent marketing campaigns and their impact over the product sales.”

In such cases, looking to the latest data on the dashboards is very important so that sustainable decisions can be made!
While monitoring the dashboards we are facilitated to see the refreshed data on the Power BI visuals using simple refresh features.
Automatic Page Refresh only works with Direct Query connection with the database, where the data can be queried at the set interval of time.

To use Automatic Page Refresh, we can drive towards the any of the report pages in Power BI Desktop and head towards the Formatting section of the visualization pane (paint roller icon). Many formatting settings can be seen there, but we will be focusing towards “Page Refresh”.

(Do Not Forget: The Page refresh card will only be available if you are connected to a DirectQuery source)
Once we click to the page refresh option, a new window will be popped-out to set the refresh settings for the report page.

1. Turns page refresh on or off.
2. Refresh type
3. Inputs and information (depending on refresh type)

While using the auto page refresh, there are two types of refreshes-

1. Fixed Interval
2. Change Detection

Real-time dashboards need the right architecture behind them, not just the right settings. Our team can help you design DirectQuery reports that scale. Explore our Data Analytics services →

Both the two have separate techniques to serve one common purpose – “Refreshed Data”.

Types of Automatic Page Refresh

Fixed Interval

This is a simpler way to directly set-up refresh schedule. By default, the schedule is 30 minutes.

You can also see the refresh details by a click over the “Show Details” button.

These details are sometimes important to look toward the recent refresh activities.

Change Detection

This one is a little bit different. Here we use some fields from our data in order to make the conditional refreshes to the data. You must be thinking, why is it so???For example, you can want to count distinct count of customer IDs and want to only refresh report when a new customer is added to the list.

We can also access the change detection window from the Modelling tab of the Power BI Desktop ribbon. When we open the change detection window, we are presented with the following sections-

1. Measure Type: This is to select whether to use an existing measure or create a new one.
   1. Choose a calculation: Here we can choose a calculation base.
   2. Choose a field: Here we can use the existing fields from the data.
   3. Check for every: Time period for check can be set here.

You can see a new measure with the change detection icon has appeared in the Fields pane.

Now, go back to the page refresh window. You can see the details about the measure being used for change detection and the defined interval for your reference.

This is all about Auto Refreshing Report pages in power Bi.
I hope you must have gained the knowledge out of this blog and make a practice to pin this to your expert visualizing hands.

Not sure if your workspace supports faster refresh intervals? Get in touch with our team →

Author By

Kamal Sharma

kamal.sharma@addendanalytics.com

Kamal brings over 20 years of experience in data analytics and business intelligence. He has led the design and implementation of analytics solutions across operations, financial reporting, and performance improvement initiatives. With a background in business statistics and Six Sigma, his work focuses on applying data in a structured and practical way to solve real business challenges.