Forum Discussion
Is Mysql cloud connection still not working?
Hi Shaaou ,
It sounds like you're encountering a common issue when connecting to MySQL in Power BI via the cloud, where the service expects an encrypted connection by default. Even though you've set the data source's encryption setting to "not encrypted," Power BI's cloud service (particularly when using the on-premises data gateway or direct cloud connectors) still attempts to establish a secure connection unless the MySQL server explicitly allows unencrypted traffic.This error typically arises when either the MySQL instance is not configured correctly to accept such connections or when Power BI cannot successfully negotiate the connection protocol due to mismatched SSL settings. To resolve this, ensure that your MySQL server has SSL explicitly disabled if you intend to use unencrypted connections, or better yet, enable SSL and provide the required certificates for a secure and supported configuration. Keep in mind that Microsoft is gradually enforcing stricter security standards, so using encrypted connections is strongly recommended and more future-proof.
Community SupportHi Shaaou,
Thank you for reaching out to the Microsoft Fabric Community Forum.
After thoroughly reviewing the details you provided, I have identified a few workarounds that may help resolve the issue. Please follow these steps:
- Verify if your MySQL server requires SSL/TLS encryption for connections. If it does, even if the Fabric connection is set to "Not Encrypted," it will fail if the server expects encrypted connections.
- In the Power BI Service >> Manage Gateways or Dataflow connection settings >> Go to your MySQL connection, then change Encryption to Encrypted (Trust server certificate). Save and refresh again.
- Ensure you're using the latest MySQL .NET connector. Older connectors may not fully support the encryption negotiation that Fabric expects.
- Some managed MySQL cloud services (e.g., Azure Database for MySQL, AWS RDS, Google Cloud SQL) enforce encryption by default. If you're using one of these, you may need to import their SSL certificate and configure the Fabric connection accordingly.
you may find useful insights in this related community thread, which discusses a similar issue with MySQL and the on-premises data gateway: Solved: Re: Power BI Gateway MySQL source doesn't support ... - Microsoft Fabric Community
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Community SupportHi Shaaou,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.