topic Re: Connecting to Mysql as directQuery mode using Mariadb Connector in DAX Commands and Tips

Connecting to Mysql as directQuery mode using Mariadb Connector

Anonymous — Tue, 08 Nov 2022 19:38:19 GMT

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.

Re: Connecting to Mysql as directQuery mode using Mariadb Connector

v-yueyunzh-msft — Wed, 09 Nov 2022 02:35:54 GMT

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