Power BI Gateway MySQL source doesn't support encrypted connections

Your gateway screenshot says "Not encrypted"  but the error message suggests a failed attempt at an encrypted connection. This doesn't add up.  Please clarify.

ALSO NOTE:  MySQL support on the gateway is BROKEN after version 66.8 (or thereabouts) and Microsoft and MySQL shift the blame to each other.

Hi @gursimranbedi，

I'm afraid that if the MySQL connection is down, there is no other way to use it with gateway properly.

The on-premises data gateway acts as a bridge to provide quick and secure data transfer between My SQL and Power BI.

By using a gateway, organizations can keep databases and other data sources on their on-premises networks, yet securely use that on-premises data in cloud services.

Users in your organization can access on-premises data to which they already have access authorization. But before those users can connect to your on-premises data source, an on-premises data gateway needs to be installed and configured.

A stored credential is used to connect from the gateway to on-premises data sources.

Regardless of the user, the gateway uses the stored credential to connect.

For more information, you can refer to this: On-premises data gateway architecture

Hope it helps,

Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.