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.
I tried to connect to MySQL database. It gives the following error. Any help please?
When I select to SQL
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.'"
Solved! Go to Solution.
Hi Nagesh, it is a high-level recomendation because I do not know more about the setup. First before uninstalling the entire program MySQL, try install this again:
mysql-connector-net-8.0.16.msi
it is the link to download the connector version 8.0.16. The version 17, its the one giving problems for some mates. Good luck!
I had the same problem with 8.0.17. I uninstalled it, and installed 8.0.16. No Errors.
Same issue. Also solved with 8.0.16. Thanks 🙂
@Anonymous Thanks It works 🙂
Hi @Anonymous ,
I am getting some different error while connecting to MySQL workbench database. Please guide me to remove this error.
ERROR:-- "MySQL: Fatal error encountered during data read."
@Tahreem24 You may need to click on the "Show Details" button to see the specific error message.
HI @Anonymous ,
Thanks for that information, error went away.
problem is gone.
Thanks
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:
I have the same issue.
Tried reinstalling both PowerBi and mysql-connector and issue stills exists.
Same issue here... Latest MySQL Connector and PowerBI Desktop...
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.
This version of MySQL Connector fixed the problem for me : https://go.microsoft.com/fwlink/?LinkId=278885
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.
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'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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |