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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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