cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerbiuser114
Frequent Visitor

Unable to Connect to MySQL database

I tried to connect to MySQL database. It gives the following error. Any help please?

 

When I select to SQL

Error Screenshot.JPG

 

Details: "An error happened while reading data from the provider: 'Could not load file or assembly 'Renci.SshNet, Version=2016.1.0.0, Culture=neutral, PublicKeyToken=1cee9f8bde3db106' or one of its dependencies. The system cannot find the file specified.'"

1 ACCEPTED SOLUTION

Accepted Solutions
andrelomartins Advocate I
Advocate I

Re: Unable to Connect to MySQL database

Solve with previous version of connector.

mysql-connector-net-8.0.16.msi

Thanks !!!

View solution in original post

35 REPLIES 35
humoon88
Frequent Visitor

Re: Unable to Connect to MySQL database

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.

Twentytwo
New Member

Re: Unable to Connect to MySQL database

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!

Smile_Park
New Member

Re: Unable to Connect to MySQL database

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.

 

 

MoritzP
Frequent Visitor

Re: Unable to Connect to MySQL database

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.

Julien_V
New Member

Re: Unable to Connect to MySQL database

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

Anonymous
Not applicable

Re: Unable to Connect to MySQL database

This version of MySQL Connector fixed the problem for me : https://go.microsoft.com/fwlink/?LinkId=278885

sgupte
Regular Visitor

Re: Unable to Connect to MySQL database

I have the same issue.

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

 

 

 

ftthbi
New Member

Re: Unable to Connect to MySQL database


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/...

Andyrice
New Member

Re: Unable to Connect to MySQL database

Same problem here.

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors