cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to connect to MYSQL Database with Power BI

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.'"

 

Tried to connect power bi Sept 2019 release with MYSql  Database ver-2017 using connector MYSQL-CONNECTOR-NET-8.0.16/17

Please help in resolving the issue. Below is the screenshot of the 
A436A5CA.PNG

Status: New
Comments
Moderator

Hi @kumari_Rashmi13

 

Please install ADO.NET Driver for MySQL (Connector/NET). If your Power BI desktop is 64 bit version, install the 64 bit version connector. Then restart the machine, open Power BI desktop try again. 

 

Best Regards,
Qiuyun Yu