Forum Discussion
Is Mysql cloud connection still not working?
- 1 year ago
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.
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.