Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone👋, a couple of days ago we have been having problems with our connection to MySQL DB, apparently it has to do with the gateway due to the type of error that PowerBI returns. We tried making some changes to the timeout parameters but did not have positive results. If anyone has experience with this that can help us, we would greatly appreciate it. This is the error that PowerBI throws:
Error del origen de datos: | {"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: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}},{"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":"mysql-risk-db.clazkjayicpp.us-east-1.rds.amazonaws.com;risk-prod"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: SII - F29 - Valid. |
URI de clúster: | WABI-PAAS-1-SCUS-redirect.analysis.windows.net |
Identificador de actividad: | 499dd5b2-4917-4fb2-8d56-db9eacc9494c |
Identificador de la solicitud: | 0b05ee80-64b6-9002-db86-d5cb5533c3ec |
Hora: | 2020-07-02 17:41:23Z |
Hi @Wailon ,
Please check if the solution in the following thread can help you solve the problem.
Best Regards
Rena