Unable to connect to any of the specified MySQL hosts

[Sbudd]

Hi all

Please if anyone could help, im getting many different errors but the main one is below.

I have many dashboard and most still work but some dont and are saying connections issues, yet other dashboards are fine.

And up til yesterday I was able to refresh using desktop but that now has given up too.

Any suggestions the issues started about a month ago.

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"MySQL: Unable to connect to any of the specified MySQL hosts."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"10478"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"MySql"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"REMOVED FOR PRIVACY REASONS"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Unable to connect to any of the specified MySQL hosts."}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Data.
Cluster URI: WABI-UK-SOUTH-D-PRIMARY-redirect.analysis.windows.net
Activity ID: 1242b12a-45df-47a3-b3eb-565f2ad54fdb
Request ID: 768c873e-9560-340e-e2aa-0fa62d2b549c
Time: 2025-09-03 09:18:35Z

[v-veshwara-msft]

Hi @Sbudd ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.

[Sbudd]

We managed to regain connection thank you, but it now no longer allowing for large data pulls. 

[v-veshwara-msft]

Hi @Sbudd ,

Thanks for confirming the connection is restored.

Since the current issue is with larger data pulls, one approach you may want to try is to start with a filtered dataset (for example, a smaller date range), publish that, and then configure incremental refresh in Power BI. This ensures that partitions are created and only new or changed data is processed during refresh, rather than reloading the full dataset every time.

It may also help to test with a custom SQL query in the connector to reduce the dataset size at the source and check whether that improves reliability. This can help confirm whether the bottleneck is related to query evaluation time or data volume.

For reference, here are some similar discussions from the community:

Solved: Can't import large dataset in desktop and service ... - Microsoft Fabric Community

Solved: Connecting via ODBC error on large datasets - Microsoft Fabric Community

Hope this helps. Please reach out for further assistance.

Thank you.

[ajinaniyan]

This error usually indicates that Power BI (through the On-premises Data Gateway or direct desktop connection) can’t establish a TCP connection to the MySQL server. Since some dashboards are still working, the server itself is probably online, but there could be differences in the data source configuration. First, double-check that the MySQL connector is installed and up to date on both your Power BI Desktop and the gateway machine. Also verify that the firewall or antivirus isn’t blocking outbound traffic on port 3306, and confirm that MySQL is configured to accept remote connections (bind-address=0.0.0.0 in my.cnf and skip-networking=0). In the Power BI service, check the data source credentials in the gateway settings — expired or cached credentials often cause intermittent failures. If local refresh has stopped working too, I’d suggest testing connectivity with mysql -h <server> -u <user> -p from the same machine running the gateway. If that fails, it’s likely a network or MySQL config issue. In rare cases, corruption in the MySQL data files can also break connections; if you suspect that (server runs but databases won’t respond), tools like Stellar Repair for MySQL can help repair and restore the database.

[v-veshwara-msft]

Hi @Sbudd ,

Thanks for reaching out to Microsoft Fabric Community.

Have you had a chance to try the suggestions already shared by @grazitti_sapna and @Nabha-Ahmed ? If the issue still persists, one additional point to verify is whether the MySQL connector you are using is up to date. Power BI relies on the MySQL .NET connector, and outdated versions can sometimes cause connection failures.

Power Query MySQL database connector - Power Query | Microsoft Learn

Similar discussion: Solved: Failed to update data source credentials: MySQL: U... - Microsoft Fabric Community

Please reach out for further assistance.

Thank you.

[Sbudd]

Thanks for everyones suggestions we are working through all them, but still having issues

[v-veshwara-msft]

Hi @Sbudd ,

Thanks for the update. Since you’re still working through the checks, please try these as well:

1. Verify whether the MySQL service is running by opening Windows Services. If it is stopped, start the service and then try connecting again.

2. When entering server details in Power BI, make sure you are using the correct hostname provided by the MySQL server. In some cases, you may need to specify the hostname with port number (for example 192.50.60.112:13287) for the connection to work.

3. Reinstall or patch the MySQL connector on your machine and also ensure you are using the latest version of Power BI Desktop to avoid compatibility issues.

4. Test the connection outside Power BI using MySQL Workbench or another MySQL client tool. If the connection fails there too, it may point to an issue with credentials or IP whitelisting. If it succeeds, then the issue may be related to the connector used by Power BI.

5. Double-check if the server IP address has changed recently. Even a small change in IP could block the connection until the new address is whitelisted or updated in your connection settings.

Please try these checks and let us know the outcome.

Similar discussions:
Unable to connect MYSQL | Details: "MySQL: Unable ... - Microsoft Fabric Community

Solved: MySQL: Unable to connect to any of the specified M... - Microsoft Fabric Community

Thank you.

[v-veshwara-msft]

Hi @Sbudd ,
Just wanted to check if the response provided was helpful. If further assistance is needed, please reach out.
Thank you.

[Nabha-Ahmed]

Hi @Sbudd 

This error means Power BI can’t reach your MySQL host. Please check:

* Gateway is installed, updated, and running.
* Port **3306** open in firewall/network.
* Re-enter MySQL credentials.

[grazitti_sapna]

Hi @Sbudd 

The issue could be typically caused by connectivity issues between Power BI and the MySQL database server. Common reasons include network connectivity problems, IP address or hostname changes, firewall restrictions, driver issues, or SSL/encryption requirements.

Here are some troubleshooting steps that you can follow and let us know if the issue still persists:

• Verify MySQL server IP/hostname and port are correct and accessible.
• Check credentials and ensure your client IP is whitelisted in MySQL firewall.
• Update to the latest MySQL ODBC driver (64-bit).
• Clear and re-enter credentials in Power BI data source settings.
• Confirm if SSL is required and configure Power BI gateway accordingly.
• Check if MySQL server IP or hostname recently changed and update connection.

Test connectivity outside Power BI (e.g., MySQL Workbench) to isolate the issue.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

🔗 Curious to explore more? [Discover here].

Let’s keep building smarter solutions together!