Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Power Bi mysql data refresh failing asking for RSA public key

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

Status: Investigating

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

Comments
v-cazheng-msft
Community Support
Status changed to: Investigating

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