error when connect power bi to mysql service

[Anonymous]

I am trying to connect Power BI to AWS RDS mysql database. But I got error below 

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

Anyone knows how to solve this problem? Thx ^

[v-jingzhang]

Hi @Anonymous 

See if these resources helpful:

How To Connect From a Power BI Desktop to a MySQL AWS RDS Instance | by WCI Data Solutions

Connecting Power BI Service to Amazon RDS MySQL data source - Microsoft Power BI Community

As in the error message, it says "The system cannot find the file specified." You may copy the endpoint from the AWS console and use the MySQL workbench to validate that you can connect with the credentials provided to the RDS, that you have permissions to run a SQL statement, and that it is returning data. (Extract from the first link)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Anonymous]

Thanks for reponse. I used the endpoint in AWS as the server when connecting to the Power Bi but still get this error.