Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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