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

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.