Forum Discussion

vanessa's avatar
vanessa
Post Patron
8 years ago

MySQL SSH on Unix (with SSH enabled) - Error - Unable to connect to any of the specified mysql hosts

I have a MySQL db hosted on Unix server with SSH enabled.

 

I am facing the following error while trying to connect to it from PBI desktop:

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    vanessa,

    Are you able to connect to MySQL from MySQL workbench? Ensure that MySQL workbench is installed in the same machine as Power BI Desktop.

    Also, please enable remote access to MySQL server following the guide in this blog. And verify the port number that MySQL is using, add the port to your firewall, then use "servername: port" connection string to connect to MySQL in Power BI Desktop and check if it is successful.

    Regards,
    Lydia

    • vanessa's avatar
      vanessa
      Post Patron
      8 years ago

      Anonymous

       

      Does  Power BI support SSH?

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        vanessa,

        Based on my research , Power BI does not support dual authentication steps like logging onto a remote server with ssh and then connecting to the database. 

        There is a similar idea about this issue, please vote it up.

        Regards,
        Lydia