Connecting MySQL over SSH with powerbi

[ash757]

Hi, I wanted to know if I could directly connect my SQL DB to powerbi over SSH tunnel.

Is it possible using powerbi service or anything else? Just need to know.

[amitchandak · Accepted solution]

@ash757 , I doubt that.
Create a rule in Putty to allow the tunneling. Then use the IP, which is allowed in Power BI.

Use Onpremise gateways while creating the connection on Power BI service semantic model settings

[Anonymous · Accepted solution]

Hi @ash757 

Thanks for the reply from @amitchandak , please allow me to provide another insight:

PowerBI does not have a built-in ability to configure access to a database protected by an SSH tunnel, the feature is currently under review, please vote for this idea:

Microsoft Idea

Here are some links for your reference:

How to Connect to MySQL database from Power BI using SSH Tunnel (supportfly.io)

🤓 ✋🏼 👆🏿 Connecting DB with SSH Tunnel to PowerBI 🏢 🕎 🧓🏽 (tech-en.netlify.app)

Power BI SSH Tunneling - Microsoft Fabric Community

Help rush urgent aid this holiday season | UNICEF (youtube.com)

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@ash757 , I doubt that.
Create a rule in Putty to allow the tunneling. Then use the IP, which is allowed in Power BI.

Use Onpremise gateways while creating the connection on Power BI service semantic model settings

[ash757]

Can you refer me a more detailed guide for setting this up?