Refresh error - MySQL connection

[NelsonLinares]

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: Fatal error encountered during data read."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: FACT_TRACE_LOGS.
Cluster URI:	WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID:	00000000-0000-0000-0000-000000000000
Request ID:	eb393638-3a81-402b-bbb9-ac78872cd664
Time:	2022-10-03 02:43:46Z

[adamc-powerbi · Accepted solution]

Hi,

This suggests either a timeout issue on the server side or a data quantity load issue.

Check out this answer to understand technicial limitations of MySQL -> PowerBI.

https://community.powerbi.com/t5/Issues/mysql-fatal-error-encountered-during-data-read/idi-p/2215569

[NelsonLinares]

We reduced the number of records to be returned