Power Bi mysql data refresh failing asking for RSA public key

[TabishSarfraz]

Until today, PowerBi was sucessfully able to connect to our MYSQL Database and refresh. 

Please note we have two datasets, connecting to two different databases on same MYSQL server.

One dataset is still refreshing correctly, while the other keeps generating the error below. 


Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"MySQL: Retrieval of the RSA public key is not enabled for insecure connections."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"MySql"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"localhost;itherapeutics_au_rx"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Retrieval of the RSA public key is not enabled for insecure connections."}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: itherapeutics_au_rx store.
Cluster URI: WABI-AUSTRALIA-EAST-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 9a02a03e-c743-44c5-a477-b64d3418f81a
Request ID: a9b5e200-eb06-1b5a-cd79-a1189ef08956
Time: 2022-02-03 03:32:22Z

[v-cazheng-msft]

Hi @TabishSarfraz 

Could you please tell me the version of your SQL Server and what kind of authentication you are using? Please refer to this link MySqlConnector/retrieval-public-key.md at master · mysql-net/MySqlConnector · GitHub

Best Regards,

Community Support Team _ Caiyun