Forum Discussion
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 ReportingServicesTools2. Import the ReportingServicesTools module
Import-Module ReportingServicesTools3. 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.
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 ...Hi pundip44 ,
Please refer below documents, hope it is helpful for you:
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.
Set-RsDataSource : No se encuentra ningún parámetro que coincida con el nombre del parámetro 'ConnectionString'.
