MySQL Connection Error

[srlabhe123]

Hi Team,

While I am trying to create a connection in Power BI desktop , wfter adding server ,databse, username and passwd credentials I am getting below error.

In one of the previous posts here suggested to reinstall Power BI dektop and MySQL connectors , which I did but still getting same error.

https://community.powerbi.com/t5/Desktop/error-value-preferred/td-p/247713

Kindly suggest.

[v-yuezhe-msft]

@srlabhe123，

I can successfully connect to MySQL database in the latest version of Power BI Desktop(2.52.4921.682).  Based on my research, preferred is one value of SSL mode, do you enable SSL for MySQL?

Moreover, do you use 64 bit or 32 bit Power BI Desktop? In your scenario, make sure that the MySQL Connector you install matches your Power BI Desktop installation (32-bit or 64-bit).

Regards,
Lydia

[srlabhe123]

I have the same version of Power BI, can you please help how to enable SSL for My SQL?

[v-yuezhe-msft]

@srlabhe123,

Please firstly check if you enable SSL for MySQL following the guide in the blog below.

http://xmodulo.com/enable-ssl-mysql-server-client.html

Regards,
Lydia