Is Mysql cloud connection still not working?

[Shaaou]

I got my Mysql data source all figured out on the cloud, and it appears to be "online". But when I try to refresh that data source, it processed for a few minutes and returned the following error:
The MySql source doesn't support encrypted connections. (Source at xxxx). The exception was raised by the IDbCommand interface

I made sure the data source's encryption is set to "not encrypted"

[v-ssriganesh]

Hi @Shaaou,

May I ask if you have resolved this issue? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[rohit1991 · Accepted solution]

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.

Passionate about leveraging data analytics to drive strategic decision-making and foster business growth.

Connect with me on LinkedIn: Rohit Kumar.

[v-ssriganesh]

Hi @Shaaou,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-ssriganesh]

Hi @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.

[v-ssriganesh]

Hi @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.