Forum Discussion
Refresh data direct query in Power Bi Service
HI dwh ,
Direct query mode, when the user clicks on the report, it sends a query to the original data to get the latest data. The official article describes it as follows.Power BI does not import data over connections that operate in DirectQuery/LiveConnect mode. Instead, 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.
Although DirectQuery mode and LiveConnect mode are similar in that Power BI forwards the queries to the source, it is important to note that Power BI does not have to transform queries in LiveConnect mode. The queries go directly to the Analysis Services instance hosting the database without consuming resources on shared capacity or a Premium capacity.
Because Power BI does not import the data, you don't need to run a data refresh. However, Power BI still performs tile refreshes and possibly report refreshes, as the next section on refresh types explains. A tile is a report visual pinned to a dashboard, and dashboard tile refreshes happen about every hour so that the tiles show recent results. You can change the schedule in the dataset settings, as in the screenshot below, or force a dashboard update manually by using the Refresh now option.
To learn more details ,refer:https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
And pls check the below in your desktop:
Power BI doesn't support Direct Query for appended tables. It will silently convert that query to Import. Go to the Model View and hover over that query and it will say Import. If you have any other tables in the model that are still Direct Query, your storage mode in the lower right corner of the Report View will say mixed.
You can merge in DQ, but you cannot append. You must set up a scheduled refresh to get those tables to be refreshed in the model.
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
HI dwh ,
Direct query mode, when the user clicks on the report, it sends a query to the original data to get the latest data. The official article describes it as follows.Power BI does not import data over connections that operate in DirectQuery/LiveConnect mode. Instead, 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.
Although DirectQuery mode and LiveConnect mode are similar in that Power BI forwards the queries to the source, it is important to note that Power BI does not have to transform queries in LiveConnect mode. The queries go directly to the Analysis Services instance hosting the database without consuming resources on shared capacity or a Premium capacity.
Because Power BI does not import the data, you don't need to run a data refresh. However, Power BI still performs tile refreshes and possibly report refreshes, as the next section on refresh types explains. A tile is a report visual pinned to a dashboard, and dashboard tile refreshes happen about every hour so that the tiles show recent results. You can change the schedule in the dataset settings, as in the screenshot below, or force a dashboard update manually by using the Refresh now option.
To learn more details ,refer:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
And pls check the below in your desktop:
Power BI doesn't support Direct Query for appended tables. It will silently convert that query to Import. Go to the Model View and hover over that query and it will say Import. If you have any other tables in the model that are still Direct Query, your storage mode in the lower right corner of the Report View will say mixed.
You can merge in DQ, but you cannot append. You must set up a scheduled refresh to get those tables to be refreshed in the model.
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Thank you, I understand
