Forum Discussion
How to connect mysql database from power bi desktop over ssh
Deep Have you tried using ODBC DSN connection to mysql db. This might help you in connecting to the MY SQL DB from powerbi. I have used similar approach to connect mysql db which was in AWS cloud to connet from powerbi. However, if your DB is required VPN connectivity, you may also need to connect to VPN before using ODBC DSN.
Further, MySQL workbench is a different tool to connect to your cloud DB. It will not help you in your powerbi connectivity.
You may refer to below link (skip 1st 60 seconds)
https://www.youtube.com/watch?v=fZV1VSRF0Zg
amitchandak How this connector connects power bi desktop to remote MySQL DB?
Do I have to connect MySQL workbench to remote MySQL DB then power bi to the workbench?
and from where I get the power bi desktop IP?
can you please elaborate
Deep , This .net connector will help power bi to connect to MySQL. If on the same machine you are able to connect with other tools. means IP access has no issues.
For IP, you can query on google What is my IP
amitchandak unable to connect. It shows "can't connect to mysql server on 'ip' (10060)"
Deep , That means user is not enabled for outside IP.
refer if this : https://stackoverflow.com/questions/8348506/grant-remote-access-of-mysql-database-from-any-ip-address
amitchandak IP is not an issue for us because we are connected through VPN and I am able to connect through MySQL using TCP/IP over ssh where I have to fill both server and DB credentials. But when I try to connect through power bi desktop there is no option for server host and password. Here I only fill DB details. I think that's the issue with Power bi desktop and connector.
Is there is any way to do so?