Forum Discussion

pundip44's avatar
pundip44
Regular Visitor
2 years ago

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

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...
Mysql connection error
OnPremise
pundip44's avatar
pundip44
Regular Visitor
2 years ago

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.