cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Automatic Page refresh x Direct Query

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,

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Automatic Page refresh x Direct Query

Hi @vinidarolt ,

 

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.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Automatic Page refresh x Direct Query

Hi @vinidarolt ,

 

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.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Kudoed Authors