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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Wailon
New Member

Problem with MySQL DB and gateway

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
2 REPLIES 2
v-yiruan-msft
Community Support
Community Support

Hi @Wailon ,

Please check if the solution in the following thread can help you solve the problem.

MS SQL server timeout

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
GilbertQ
Super User
Super User

Hi there

Could you chat to your DBA and see when the queries are being run, what is happening on the database server?

It appears that it is not sending the data back in time.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors