Need help Connecting PowerBI desktop to Azure MySQL with SSL

[Anonymous]

I need some help setting up my connection with PowerBI to Azure Database for MySQL flexible server. I can't seem to find any reliable documentation to do this.

Initially I'm getting this error when I try to connect to the server.

1. Get Data > More > Select MySQL Database
2. Input the Server name and Database name > Hit OK

Error: Connections using insecure transport are prohibited while --require_secure_transport=ON.

Then I downloaded the SSL certificate from our Azure portal then successfully imported in the certmgr.msc under the Trusted Root Certification Authorities

But the same issue persists. Please take note that in this same machine I was able to connect to that server using phpmyadmin. In DbBeaver as well by simply installing the SSL as a CA Certificate. Can you please point me to the right direction or drop anything here you think I might be missing or need.

Thank you so much!

[Anonymous · Accepted solution]

Able to fix my issue by installing the latest mySQL connector and importing a public SSL Certificate.

my machine previously has a MySQL Connector Net 7.0.2 then I downloaded the latest 8.0.32 from this page: https://dev.mysql.com/downloads/connector/net/

thanks to this reference: https://learn.microsoft.com/en-us/azure/mysql/flexible-server/connect-with-powerbi-desktop