MySQL: Retrieval of the RSA public key is not enabled for insecure connections.

[niconicotsuka]

I am unable to connect a MySQL 8 database server. When I enter the server IP and database name and click the "OK" button, the following error message appears and I cannot proceed.

MySQL: Retrieval of the RSA public key is not enabled for insecure connections.

My versions are as follows:

PowerBI Desktop version 2.141.1253.0 64bit

Mysql .NET 9.2.0

This is apprently a common issue with MySQL and the common fix quoted is add allowPublicKeyRetrieval=true to the connection string except I cant see how the edit the connection string.

[v-sgandrathi]

Hi @niconicotsuka,

Thank you for reaching out to Microsoft Community Forum.

You are encountering the error "MySQL: Retrieval of the RSA public key is not enabled for insecure connections" when connecting Power BI Desktop to a MySQL 8 server. You are correct that adding allowPublicKeyRetrieval=true to the connection string is the common fix.

To resolve this in Power BI, please follow these steps:

• In Power BI Desktop, go to Get Data > MySQL Database.
• Enter your Server IP and Database Name as usual.
• Click on Advanced options to expand additional settings.
• In the field for additional settings, enter the following: allowPublicKeyRetrieval=True;useSSL=False;

By adding both options, you should be able to establish a successful connection.

I hope my suggestions provided valuable insights. If you have any further questions, don’t hesitate to ask in a follow-up message.

If this post helped, please mark it as "Accept as Solution" so others can benefit as well.

Best regards,
Sahasra

[niconicotsuka]

hi Sahasra.

As for the additional fields, the only ones I can see are "Command timeout in minutes" and "SQL statement", and I can't find a field to enter a connection string.

Is there anything else I should check?

Thanks!

[v-sgandrathi · Accepted solution]

Hi @niconicotsuka,

Thank you for your follow-up. In Power BI Desktop, the built-in MySQL connector does not allow directly appending connection string parameters like allowPublicKeyRetrieval=True;useSSL=False in the Server field or Data Source Settings. Therefore, you cannot modify the connection string directly through the "Advanced options" or by editing the data source. The recommended approach is to use an ODBC connection, where you can fully configure the connection string with the required parameters. Alternatively, you can adjust these settings at the server or driver level.

Please Accept as solution if this meets your needs and a Kudos would be appreciated.