Problem with MySQL connector.

[k3rz0rg]

Hello,

I was trying to use the MySQL connector from power bi desktop but it was giving me the following error message.

Learn more takes me to the MySQL driver download oracle site which I've already done to create ODBC connection.

I re-installed it but still PBI Desktop is giving me this message.

Can somebody tell what else I need to do to use this? Right now to satisfy the management, I'm using MySQL through ODBC dsn but why use ODBC where Power BI has the direct connector right?

Thanks,

k3.

[KasparsT]

Same for me, installed 8.0.30 restarted computer and still not detecting connector

[v-jingzhang · Accepted solution]

Hi @k3rz0rg 

I refer to the following blog and video. After installing the MySQL connector, you need to restart Power BI Desktop or restart the computer. 

Power BI Connecting to a database: Connect the MYSQL database to Power BI to build Dashboards - YouT...

Connect Power BI with MySQL Database

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Anonymous]

Thank you its really useful video.

[amitchandak]

@k3rz0rg , Please install latest .net connector  and try

https://dev.mysql.com/downloads/connector/net/8.0.html

[k3rz0rg]

Yes I already have that installed that, PBI Desktop is still not detecting unfortunately.