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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
wanna
Helper I
Helper I

Direct Query Mode

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.

3 REPLIES 3
Anonymous
Not applicable

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
Super User
Super User

Hi @wanna 

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




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





I am using MySQL as my data source.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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.

Top Solution Authors
Top Kudoed Authors