Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Solved! Go to Solution.
Hi, @Syndicate_Admin
Steps to connect to MySQL via SSH using Power BI:
Open Power BI Desktop: Open Power BI Desktop on your computer. click Get Data on the Home tab.
In the Get Data window, select MySQL Database from the list of available data sources. Click Connect.
In the MySQL Database window, enter the server details:
Server: Enter the host name or IP address of the MySQL server.
Database (optional): Enter the name of the database to connect to.
User Name: Enter your MySQL user name.
Password: Enter your MySQL password.
Click OK.
Configure the SSH tunnel:
In the MySQL Database window, click the Advanced Options link.
Check the box labeled Connect via SSH.
Enter the SSH server details:
SSH Host: Enter the host name or IP address of the SSH server.
SSH Port: Enter the SSH port (usually 22).
SSH User Name: Enter your SSH user name.
Authentication Type: Select either Password or SSH Key Pair.
If you are using an SSH key pair, provide the path to your private key file.
Click OK.
Test the connection:
After configuring the SSH tunnel, click Connect.
Power BI establishes an SSH tunnel with the SSH server and then uses the tunnel to connect to the MySQL database.
If the connection is successful, you will be able to preview the data in the MySQL database.
Load Data: After previewing the data and verifying the connection, click Load to import the data into Power BI.
Best Regards,
hackcrr
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Syndicate_Admin
Steps to connect to MySQL via SSH using Power BI:
Open Power BI Desktop: Open Power BI Desktop on your computer. click Get Data on the Home tab.
In the Get Data window, select MySQL Database from the list of available data sources. Click Connect.
In the MySQL Database window, enter the server details:
Server: Enter the host name or IP address of the MySQL server.
Database (optional): Enter the name of the database to connect to.
User Name: Enter your MySQL user name.
Password: Enter your MySQL password.
Click OK.
Configure the SSH tunnel:
In the MySQL Database window, click the Advanced Options link.
Check the box labeled Connect via SSH.
Enter the SSH server details:
SSH Host: Enter the host name or IP address of the SSH server.
SSH Port: Enter the SSH port (usually 22).
SSH User Name: Enter your SSH user name.
Authentication Type: Select either Password or SSH Key Pair.
If you are using an SSH key pair, provide the path to your private key file.
Click OK.
Test the connection:
After configuring the SSH tunnel, click Connect.
Power BI establishes an SSH tunnel with the SSH server and then uses the tunnel to connect to the MySQL database.
If the connection is successful, you will be able to preview the data in the MySQL database.
Load Data: After previewing the data and verifying the connection, click Load to import the data into Power BI.
Best Regards,
hackcrr
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |