cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

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 New Member
New Member

Re: Unable to Connect to MySQL database

Solve with previous version of connector.

mysql-connector-net-8.0.16.msi

Thanks !!!

33 REPLIES 33
humoon88 Frequent Visitor
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
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 Frequent Visitor
Frequent Visitor

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
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 Frequent Visitor
Frequent Visitor

Re: Unable to Connect to MySQL database

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

julesl Visitor
Visitor

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 Visitor
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
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
New Member

Re: Unable to Connect to MySQL database

Same problem here.

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 99 members 1,357 guests
Please welcome our newest community members: