Reply
NZ0090
Frequent Visitor

Turning on data refresh with direct query

Hi everyone! I've created a report using direct query connection to Azure SQL database. From my understanding, direct query means that data gets updated in real time but I noticed that there is a Scheduled Refresh section in my published dataset where I can select the time the dataset gets refreshed. My question is, is it necessary to set up Scheduled refresh with direct query? Or is scheduled refresh only necessary when you're using Import/Mixed connection? Thank you in advance!

 

Screenshot 2022-12-08 151411.jpeg

1 ACCEPTED SOLUTION

Hi @NZ0090 ,

 

Power BI doesn't import data over connections that operate in DirectQuery mode. The dataset returns results from the underlying data source whenever a report or dashboard queries the dataset. Power BI transforms and forwards the queries to the data source.

 

Because Power BI doesn't import the data, you don't need to run a data refresh. However, Power BI still performs tile refreshes and possibly report refreshes . In addition, if the gateway is not configured, the report of the DQ connection mode cannot obtain the latest data.

 

Whether you need to configure scheduled refresh for reports in Direct Query mode depends on your needs.

 

Please refer to the following document for more information.

Data refresh in Power BI - Power BI | Microsoft Learn

 

Best Regards,

Neeko Tang

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

3 REPLIES 3
IIPowerBlog
Helper I
Helper I

hello, Direct Query means that opening or refreshing a report or dashboard will always show the latest data in the source! 

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

Hi! Yes I do know that, but my question is whether it's necessary to set scheduled refresh if I'm using direct query.

Hi @NZ0090 ,

 

Power BI doesn't import data over connections that operate in DirectQuery mode. The dataset returns results from the underlying data source whenever a report or dashboard queries the dataset. Power BI transforms and forwards the queries to the data source.

 

Because Power BI doesn't import the data, you don't need to run a data refresh. However, Power BI still performs tile refreshes and possibly report refreshes . In addition, if the gateway is not configured, the report of the DQ connection mode cannot obtain the latest data.

 

Whether you need to configure scheduled refresh for reports in Direct Query mode depends on your needs.

 

Please refer to the following document for more information.

Data refresh in Power BI - Power BI | Microsoft Learn

 

Best Regards,

Neeko Tang

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

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)