Forum Discussion
MySQL: Retrieval of the RSA public key is not enabled for insecure connections.
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.
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
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!
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.
