Direct Query Mode

[wanna]

Currently, Power BI Data Refresh is scheduled to a specific time period.

I found that Realtime Refresh is possible if I use Direct Query, which is different from the existing method.

There are two main ways to bring data into Power BI:

Import Mode: Currently in use, data is brought in from the endpoint and scheduled refresh is performed (not real time)
Direct Query Mode: I understand that the original table is loaded directly (real time)
In short, if Direct Query Mode is possible, it seems that real-time sales reports will be possible.

MySQL in Power BI does not support Direct Query Mode, but MariaDB and SQL Server are supported.

If you know how to solve this situation, please comment.

[Anonymous]

Hi @wanna ,

If I understand correctly, the issue is that you want to set up Direct Query with a MySQL database. Please try the following methods and check if they can solve your problem:

1.Click on the Get Data and select MySQL database.

2.In the window, provide the necessary details to connect to the MySQL database.

3.After the connection is established, select Direct Query for the data connectivity mode.

4.Choose the tables you want to include in the report.

Best Regards

[PijushRoy]

Hi @wanna 

I am not clear about your question. What is your data source, MySQL, MariaDB, or SQL Server?

[wanna]

I am using MySQL as my data source.