Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.