Can't setup Power BI gateway connection with a Azure Mysql db that uses am SSL certificate

[charlkeet]

Ive setup a Azure MySQL db that connects to a Power BI report. I've downloaded the power BI gateway on my VM to refresh the Power BI report data. I can't seem to setup the gateway, getting the following error: Connections using insecure transport are prohibited while --require_secure_transport=ON. I've setup the MySQL db using a SSL CA key. I asume it's this that is prohibiting the connection as I have setup gateways before where the MySQL db doesn't have an SSL key. Is there a work around? I've come across 2 options so far:

1. remove the SSL Key

2. Use Azure SQL where I don't need the gateway (I would prefer to not go this route)

[charlkeet]

I've downloaded the SSL public certificate from the Azure portal and I've added the downloaded certificate to Trusted Root Certification Authorities on the VM. I've downloaded the personal gateway on the VM and it's running, but still when on the datatsource settings I get the error "Failed to test the connection to your data source. Please retry your credentials." and when re-entering credentials I still get the error "Connections using insecure transport are prohibited while -- require_secure_transport = ON"

[GilbertQ · Accepted solution]

Hi @charlkeet 

As far as i am aware you would need to install the SSL CA Key on the Gateway server so that it can then connect to the MySQL DB?

You should be able to follow these steps below to get it working: SSL Security Error with Data Source | Microsoft Power BI Blog | Microsoft Power BI