Automatic Page refresh x Direct Query

[Anonymous]

Hello Everyone! Can someone please clarify on this, I think I am missing something:

The automatic page refresh is avaliable with direct query, and can be set to refresh the report in as little as 2 seconds. But what good is it for, since the Direct Query itself can be updated just every 15 minutes?

Thanks,

[v-xicai · Accepted solution]

Hi @Anonymous ,

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.

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.

For low refresh intervals like one second, take factors like the following into consideration:

• The type of the DirectQuery data source
• The load your queries create on it
• The distance of your report viewers from the capacity's datacenter

In addition, the Direct Query itself can't be updated every 15 minutes, you may need to enter the duration interval in automatic page refresh page.

You can estimate return times by using Performance Analyzer in Power BI Desktop. See more details: Automatic page refresh in Power BI Desktop.

Best Regards,

Amy 

Community Support Team _ Amy

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