Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
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
Hi @wanna
I am not clear about your question. What is your data source, MySQL, MariaDB, or SQL Server?
Proud to be a Super User! | |
I am using MySQL as my data source.