CODEWITHSUNDEEP
mysqlsshserverpowerbisystem-administration
Stefano Maglione
Stefano Maglione

Reputation: 4150

Power bi to Mysql on localhost

I want to connect power bi to a MySql db that is on an a remote server and allows only localhost connection. I know power bi does not support ssh by itself so I can't use it like in Workbench. Is there any workaround to connect powerbi to a remote mysql db?

Upvotes: 0

Views: 6986

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40204

I can do it on my machine as follows:

  1. Choose Get Data > SQL Server from the Home tab
  2. Type localhost into the Server field
  3. Click OK
  4. Specify Credentials
  5. Click Connect

Upvotes: 2

Related Questions