cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Is DirectQuery Real Time or Needs Refresh

I just want to clarify the following from Microsoft's official documentation.

 

From what I understand, when you're connected through DirectQuery mode, you're data in the Report is always up to date. This means, I don't need to schedule any refresh in Power BI Service. The refresh is only relevant when I have a Power BI dashboard. Is my understanding correct? If not, can anyone shed some light about this?

 

Thanks in advance!

 

DirectQuery Refresh vs Realtime.png

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

2 ACCEPTED SOLUTIONS
hnguy71
Solution Supplier
Solution Supplier

DirectQuery has live data which is the most current data. However, in order for your visual to update with the current data you'll still need query the source, ie, choose REFRESH button. 

 

Take note that you will also be limited with transformations and dax

View solution in original post

TomMartens
Super User
Super User

Hey,

 

using the connection mode "direct query" mode means:

  • your data will not be copied into the Power BI data model
  • whenever a user interacts with a visual (a slicer, a barchar ...) queries will be generated that are querying the data source, for this reason it is valid to say that the visuals will show the most recendt data. But the report will not update automatically, just due user interaction.
  • Dashboard tiles will be refreshed automatically every 15min.

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

2 REPLIES 2
TomMartens
Super User
Super User

Hey,

 

using the connection mode "direct query" mode means:

  • your data will not be copied into the Power BI data model
  • whenever a user interacts with a visual (a slicer, a barchar ...) queries will be generated that are querying the data source, for this reason it is valid to say that the visuals will show the most recendt data. But the report will not update automatically, just due user interaction.
  • Dashboard tiles will be refreshed automatically every 15min.

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

hnguy71
Solution Supplier
Solution Supplier

DirectQuery has live data which is the most current data. However, in order for your visual to update with the current data you'll still need query the source, ie, choose REFRESH button. 

 

Take note that you will also be limited with transformations and dax

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!