Change Detection Refreshing Visuals Even With No Changes

[tmartin]

My model is set up to direct query from a few dataflows. Those dataflows are refreshed by Power Automate when the modified data of the Excel file changes.

In PBI Desktop, I enabled Page Refresh using Change Detection every 1 minute based on a measure that references the modified date.

After publishing it to the service, things work well. When the excel file is updated, Power Automate triggers a refresh of the dataflows, change detection picks up on the update and the visuals all refresh.

My issue is that the visuals are refreshing every minute or so, even if no changes have been made. From my understanding, the purpose of change detection is so that the visuals only need to refresh when a change is detected. 

Any thoughts as to why my visuals are refreshing even if no changes occur?

[tmartin]

@Anonymous 

These are the settings I have in the desktop file when I publish

Should I change my settings? Or should that be working how I would expect it to?

[Anonymous]

Hi @tmartin ,

When automatic page refresh is enabled, Power BI Desktop is constantly sending queries to your DirectQuery source. After the query is sent, there's a delay before data is returned. So, for short refresh intervals, you should confirm that queries are successfully returning the queried data within the configured interval. If data isn't returned within the interval, visuals will update less frequently than configured.

These considerations apply for both refresh types: fixed interval and change detection. The main difference will be that for change detection there is only one query going back to the source at a fixed interval and the visuals refresh is triggered only when the value of the change detection measure changes.

As a best practice, the refresh interval should at least match your expected new data arrival rate:

• If new data arrives at the source every 20 minutes, your refresh interval can't be less than 20 minutes.
• If new data arrives every second, set the interval to one second.

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @tmartin ,

We notice that you have configured page refresh in Fixed interval. It was the cause.

This refresh type allows you to update all visuals in a report page based on a constant interval such as one second or five minutes. When that specific interval is reached, all visuals in that page send an update query to the data source and update accordingly.

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.