topic Re: MySQL: Retrieval of the RSA public key is not enabled for insecure connections. in Report Server

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

pundip44 — Thu, 11 Jan 2024 09:41:05 GMT

I am unable to refresh a MySQL 8 datasource in a on prem version of Power BI reporting server. When I go in the datasouce and enter credentials under with Basic Authentication type and test I get the error:

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

My versions are as follows:

PBRIS on premisis version 15.0.1112.48

Mysql .NET 8.0.28

I am able to refresh the datasource in PowerBI Desktop RS version Version: 2.117.984.0 64-bit (May 2023)

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.

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

Anonymous — Fri, 12 Jan 2024 08:38:52 GMT

Hi pundip44 ,

To change the connection string, you might need to use PowerShell scripts to interact with the Report Server's API.

Please try below steps:

1. Open PowerShell and ensure you have the Reporting Services Tools module installed. If you don't have it, you can install it using the following command:

Install-Module -Name ReportingServicesTools

2. Import the ReportingServicesTools module

Import-Module ReportingServicesTools

3. Connect to your Power BI Reporting Server using the `Connect-RsReportServer` cmdlet.

4. Use the `Set-RsDataSource` cmdlet to update the data source connection string. The exact command will depend on your server setup, but it will be something like:

Set-RsDataSource -ReportServerUri 'http://<YourReportServerURL>' -DataSourcePath '/path/to/your/datasource' -DataSourceUsername 'yourusername' -DataSourcePassword 'yourpassword' -ConnectionString "your connection string;allowPublicKeyRetrieval=true;"

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

pundip44 — Wed, 17 Jan 2024 00:51:34 GMT

I am not sure how to do step 3. " Connect to your Power BI Reporting Server using the `Connect-RsReportServer` cmdlet." Also I just want to check that the -DataSourceUsername references the MySQL username? I ask as I am getting this error:

Set-RsDataSource : A parameter cannot be found that matches parameter name 'DataSourceUsername'.
At line:1 char:92
+ ... ReportServer' -DataSourcePath '/acc/acc/' -DataSourceUsername 'remote ...

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

Anonymous — Mon, 22 Jan 2024 08:38:05 GMT

Hi pundip44 ,

Please refer below documents, hope it is helpful for you:

ReportingServicesTools/ReportingServicesTools/Functions/CatalogItems/Set-RsDataSource.ps1 at master · microsoft/ReportingServicesTools · GitHub,

ReportingServicesTools/ReportingServicesTools/Functions/CatalogItems/Set-RsDataSource.ps1 at master · microsoft/ReportingServicesTools · GitHub

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

ca-mi-lo — Fri, 17 Jan 2025 19:43:30 GMT

Set-RsDataSource : No se encuentra ningún parámetro que coincida con el nombre del parámetro 'ConnectionString'.