Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Unable to connect to MYSQL Database with Power BI

Submitted by Anonymous on ‎10-09-2019 01:16 AM

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
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎10-09-2019 11:39 PM

Hi @Anonymous, 

 

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

Idea Statuses