Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
We have a requirement to monitor frequently updated data via Power bi and will be embedded in a web application, the data source is actually Mysql,
Since MySQL Does not support DirectQuery Mode, I managed to connect to it via a MariaDB connector (which is usable to connect to Mysql Database), and the DirectQuery works perfectly fine with MySQL using this connector,
I also managed to set up a gateway so it could connect to our locally hosted virtual machine that hosts the Mysql server,
Everything seems to work fine.
My question is, is this approach reliable enough to go to production? Should I expect any "weird" behavior, for example, if the data grows?
I appreciate your help.
Solved! Go to Solution.
Hi , @Anonymous
As far as I know, you implemented Direct Query using the Mariadb Connector tool to connect to your Mysql database.
For Direct Query mode, which is a real-time connection mode, every time we load a visual, we will send a query like the underlying data source, the speed of the query depends on the load of the underlying data source, for your question, I think as long as the load of the underlying data source is enough to support your report query, there will be no problem.
For more information, you can refer to :
Using DirectQuery in Power BI - Power BI | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @Anonymous
As far as I know, you implemented Direct Query using the Mariadb Connector tool to connect to your Mysql database.
For Direct Query mode, which is a real-time connection mode, every time we load a visual, we will send a query like the underlying data source, the speed of the query depends on the load of the underlying data source, for your question, I think as long as the load of the underlying data source is enough to support your report query, there will be no problem.
For more information, you can refer to :
Using DirectQuery in Power BI - Power BI | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
51 | |
27 | |
24 | |
13 | |
9 |
User | Count |
---|---|
74 | |
56 | |
47 | |
16 | |
12 |