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 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.
An error occurred creating the configuration section handler for system.data: Column 'InvariantName'
An error occurred creating the configuration section handler for system.data: Column 'InvariantName' is constrained to be unique. Value 'MySql.Data.MySqlClient' is already present. (C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config line
Couldn't connect to MySQL database data source issue to schedule refresh
Hi everyone, We're trying to schedule a refresh of our dashboards but we couldn't get through the MySQL data source. The MySQL database that we've connected to is from one of our supplier while our company is using SQL Server. We have successfully tested the connection to the SQL Server source but we're just having error with the MySQL data source (as pictured below). We have installed the Connector Net v. 28 and also made sure that the credentials we are using are correct. Can you please point out what are we missing here? Thank you in advance guys! 🙂
Mysql db cannot access or establish a connection through power bi
Dear Experts I’m trying to access MySQL db located on digital ocean cloud , My SQL Server available on PHP MyDAMIN please check the scree-shot below: Now I’m trying to access MySQl DB through power bi I got the following error: I downloaded My SQL connector from this link: https://dev.mysql.com/downloads/installer/ I install it (the connection) but I have the same error , please advice me how to solve this problem?
