Unable to connect to Mysql database with ssl security.

[supriya_13]

Hi Everyone ,
I'm trying to connect to mysql database in power bi desktop,it shows Encryption support error stating "we were unable to connect to the dats source using encryted connection. To access click OK."
Even if I click on OK , then I'm getting other error stating "we encountered an error while trying to connect. Details: "MySQL: Reading from the stream has failed.""
1) I can't turn off SSL security on server
2) I tried with File->Options and Settings -> Data Source Settings, choose data source and select Edit and uncheck "Encrypt Connections" option.But this doesn't work.

[Anonymous]

Hi @supriya_13 ,

You may refer to this topic which has similar error.

https://community.powerbi.com/t5/Power-Query/How-to-connect-to-a-datasource-with-SSL/m-p/663934 

Best Regards,
Jay

[amitchandak]

@supriya_13 , have you already installed latest .net driver

https://dev.mysql.com/downloads/connector/net/

[supriya_13]

yes, the drive is already installed.