- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi! Yes I do know that, but my question is whether it's necessary to set scheduled refresh if I'm using direct query.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 02-02-2023 12:05 AM | ||
06-19-2024 07:36 PM | |||
01-23-2024 04:15 AM | |||
Anonymous
| 04-17-2024 10:27 AM | ||
01-04-2024 11:43 PM |
User | Count |
---|---|
48 | |
32 | |
31 | |
27 | |
23 |
User | Count |
---|---|
40 | |
33 | |
19 | |
18 | |
16 |