Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
hruthik_raj
New Member

Failed to update data source credentials: MySQL: Unable to connect to any of the specified MySQL

I'm trying to connect my on premise mysql server with Power BI service using a personal gateway. the gateway is running without any issues. However when I'm trying to configure my databases using credentials (user: root password : #mypassword), I'm getting below error: 

Failed to update data source credentials: MySQL: Unable to connect to any of the specified MySQL

 and I could connect to these databases in Power BI desktop without any issues. Unsure about what might be the issue.

 

Attaching the image below for the referenece.

 

hruthik_raj_0-1749177298085.png

 

2 ACCEPTED SOLUTIONS
v-pgoloju
Community Support
Community Support

Hi @hruthik_raj,

 

Thank you for reaching out to the Microsoft Fabric Forum Community.


Can You please try below troubleshoot Points to resolve the issue:

Change localhost to your actual server  name.

Open port 3306 on the MySQL server.

Use mysql native password for the MySQL user.

Ensure network access from the gateway to the MySQL server.

Update gateway to the latest version.

 

If you find this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to support others in the community.



Best regards,
Prasanna Kumar

View solution in original post

rohit1991
Super User
Super User

Hi @hruthik_raj,

From the error message and the screenshot you provided, it looks like Power BI Service is unable to connect to your on-premises MySQL server even though your personal gateway appears to be running and the connection works fine in Power BI Desktop. This issue is often caused by a few common factors:

 

First, double-check that your gateway is not just installed, but also properly configured and running on the machine where the MySQL server is accessible. Unlike Power BI Desktop, which connects directly from your computer, Power BI Service relies on the gateway to act as a bridge between the cloud and your on-premises data.

 

Second, verify that the MySQL server allows connections from the gateway host. If you're using "localhost" as the server name, remember that when the gateway tries to connect, "localhost" refers to the gateway machine, not necessarily the database server machine. If your MySQL server is on a different machine, use its actual network name or IP address instead.

 

Additionally, check firewall settings on both the MySQL server and the gateway machine to ensure the relevant port (usually 3306 for MySQL) is open. Also, make sure the root user is allowed to connect remotely, not just from localhost, by checking the user’s host permissions in MySQL.

 

Finally, confirm that you have the correct MySQL connector/ODBC driver version installed on the gateway machine, as mismatched drivers can sometimes cause connection problems. If all else fails, try restarting both the gateway service and your MySQL server, and double-check that the credentials you’re entering in Power BI Service exactly match those used in Power BI Desktop.

 

If you’ve checked all these and the issue persists, providing the exact gateway logs may help further diagnose the connection failure.


Did it work? ✔ Give a Kudo • Mark as Solution – help others too!

View solution in original post

5 REPLIES 5
v-pgoloju
Community Support
Community Support

Hi @hruthik_raj,

 

Just checking in to see if your issue has been resolved. If you’ve found a fix whether from the responses here or through your own troubleshooting it would be great if you could share it with the community.

This helps others facing similar challenges benefit from your experience.

Thanks again for your time and contribution!

Best,
Prasanna Kumar

v-pgoloju
Community Support
Community Support

Hi @hruthik_raj,

 

Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

 

Best regards,

Prasanna Kumar

rohit1991
Super User
Super User

Hi @hruthik_raj,

From the error message and the screenshot you provided, it looks like Power BI Service is unable to connect to your on-premises MySQL server even though your personal gateway appears to be running and the connection works fine in Power BI Desktop. This issue is often caused by a few common factors:

 

First, double-check that your gateway is not just installed, but also properly configured and running on the machine where the MySQL server is accessible. Unlike Power BI Desktop, which connects directly from your computer, Power BI Service relies on the gateway to act as a bridge between the cloud and your on-premises data.

 

Second, verify that the MySQL server allows connections from the gateway host. If you're using "localhost" as the server name, remember that when the gateway tries to connect, "localhost" refers to the gateway machine, not necessarily the database server machine. If your MySQL server is on a different machine, use its actual network name or IP address instead.

 

Additionally, check firewall settings on both the MySQL server and the gateway machine to ensure the relevant port (usually 3306 for MySQL) is open. Also, make sure the root user is allowed to connect remotely, not just from localhost, by checking the user’s host permissions in MySQL.

 

Finally, confirm that you have the correct MySQL connector/ODBC driver version installed on the gateway machine, as mismatched drivers can sometimes cause connection problems. If all else fails, try restarting both the gateway service and your MySQL server, and double-check that the credentials you’re entering in Power BI Service exactly match those used in Power BI Desktop.

 

If you’ve checked all these and the issue persists, providing the exact gateway logs may help further diagnose the connection failure.


Did it work? ✔ Give a Kudo • Mark as Solution – help others too!
v-pgoloju
Community Support
Community Support

Hi @hruthik_raj,

 

Just following up to see if the  provided troubleshoot points was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful  this will benefit others in the community as well.

 

Best regards,

Prasanna Kumar

v-pgoloju
Community Support
Community Support

Hi @hruthik_raj,

 

Thank you for reaching out to the Microsoft Fabric Forum Community.


Can You please try below troubleshoot Points to resolve the issue:

Change localhost to your actual server  name.

Open port 3306 on the MySQL server.

Use mysql native password for the MySQL user.

Ensure network access from the gateway to the MySQL server.

Update gateway to the latest version.

 

If you find this response helpful, please consider marking it as the accepted solution and giving it a thumbs-up to support others in the community.



Best regards,
Prasanna Kumar

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.