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,
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.