Refresh data direct query in Power Bi Service

[dwh]

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

[v-luwang-msft · Accepted solution]

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

[dwh]

Thank you, I understand

[dwh]

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