Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
dwh
Helper II
Helper II

Refresh data direct query in Power Bi Service

Hello everyone,
I published a report in power bi service where the data source is in direct query, how can I automatically refresh the data?
My report was published on a personal app through the pro licensed power bi embed service.
The application is customer and non organization type and the application was developed in the react language.
I would like to be able to update the data every time the application is opened and the token is requested in the backend.
Thanks to those who can offer me help

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

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.

vluwangmsft_0-1650854771732.png

 

vluwangmsft_1-1650854771456.png

 

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

View solution in original post

3 REPLIES 3
v-luwang-msft
Community Support
Community Support

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.

vluwangmsft_0-1650854771732.png

 

vluwangmsft_1-1650854771456.png

 

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

dwh
Helper II
Helper II

I have to add that my dataset is made up of tables in direct query but then I did an append between them to get a table, otherwise I didn't know how to create a matrix

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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