Forum Discussion
Turning on data refresh with 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.
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.