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 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.