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 |
