How to connect Power BI Desktop to remote MySql server that requires authentication

Question

I am having a My SQL database and I am running on a remote server that required ssh authentication and need to connect to Microsoft Power Bi, I can't able to manage both server ssh authentication and the database user logon information.

Answer 1

1. Create a gateway and then connect to the server
2. And then it will be asked to connect to the server port and database username and password

    Interested to Learn Power Bi in detail? Come and Join the Power bi certification by Intellipaat.

   Also, watch our YouTube video on Power Bi Courses to get yourself started.