Forum Discussion

Shaaou's avatar
Shaaou
Regular Visitor
1 year ago
Solved

Is Mysql cloud connection still not working?

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: T...
  • rohit1991's avatar
    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.