Power BI to GCP MYSQL Connection using SSL

[kasivasu]

Greetings 

I am getting an error when trying to make a connection from Power BI to a MYSQL Database on the Google Cloud Platform

When I turn off SSL connection in GCP, I am able to connect to the database and see the database tables in Power BI

But, when I turn on "need ssl", I get a message "We couldn't authenticate you with the credentials provided. Please try again"

Details:

Our MYSQL Database is on a Google Platform with publicly available IP address

Enabled SSL.

I have downloaded the server certificate as well from the platform. server-ca.pem

I understand that Power BI uses windows trusted root certification (based on a blog on MMC) to use SSL

https://powerbi.microsoft.com/es-es/blog/ssl-security-error-with-data-source/ (Partially atleast ....Since I downloaded the server certificate from google, I didn't create a certificate locally)

I used my admin id and followed the instructions to add it and can confirm that the certificate has been added and it seems ok (image below)

But Power BI is refusing to connect now. I get a message "We couldn't authenticate you with the credentials provided. Please try again"

If someone could point out how to solve this, it would be great. 

[Anonymous]

Hi @kasivasu ,

There is no SSL certification when you connect My SQL Database in Power BI Desktop. More details you can refer to this post.

Best Regards,

Stephen Tao

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