Unable to Connect to MySQL database

I had the same problem with 8.0.17. I uninstalled it, and installed 8.0.16 from here: https://mirrors.dotsrc.org/mysql/Downloads/Connector-Net/ . Error went away. 

Hello,

I have fixed that issue by using an older version fo the mysql-connector...

Here a link that I will share for some time: mysql-connector-net-8.0.12 (x64)

Hope that will help some of you :)

pH

Same here.

Connection to mysql is not working on PowerBI desktop, PBI gateway or even by PowerQuery in excel. All three returns same error about renci.sshnet dll.

OS: Windows Server 2019 on Amazon Web Services.

Latest version of .Net and mysql connectors installed.

Related post:

https://community.powerbi.com/t5/Service/MySQL-Connection-via-PowerBI-Gateway-returns-odd-error/m-p/746332

Hi,

I solved this problem by uninstalling the latest version of MySQL Connector (8.0.17) and installing the 8.0.15. I followed this video : https://www.youtube.com/watch?v=VC9h7yVRHV8

And this is the link to download the version 8.0.15 : https://downloads.mysql.com/archives/c-net/

Good luck you all.

I'm having this same problem - but it is on the PowerBI App service.

The local desktop connects just fine.

Make sure you have the most up-to-date MySQL Connectors. Maybe that will help.

I'm unsure how to address this error o App.powerbi.com however.

I have the same issue here. Using the latest Mysql connector doesn't solve the error. 

Does anyone know how to solve it? 

Thanks a lot!

I also have problem same as you.

I tried with latest Mysql connector and Mysql version 5.x and 8.x. It didn't work 

Please let me know if someone has a solution.

same issue here. it worked this morning on both desktop and app service, now it broke on both.

I tried reinstalling Power BI Desktop as well as the MYSQL Connector multiple times.

Same issue here... Latest MySQL Connector and PowerBI Desktop...

I have the same issue.

Tried reinstalling both PowerBi and mysql-connector and issue stills exists.