MySQL Fatal Data Read Error During Power BI Refresh (OLE DB or ODBC Error)

Hi all,

I'm facing a persistent issue while refreshing my Power BI dashboard that's connected to MySQL.

Problem:

When I run a full refresh, I get errors in the following tables:

• DAX Tables

• DimAFMapping

• Prod-Cat-Subcat

• Customer

However, when I refresh these tables individually, the DAX tables refresh successfully without any errors.

The issue persists in the following tables:

• Cust_new

• FactReciept

• FactRecieptitem

• Prod_Cat_Subcat

Error message:

OLE DB or ODBC error: [DataSource.Error] MySQL: Fatal error encountered during data read.

Additional info:

• Using MySQL Connector/ODBC for the connection.

• This issue only occurs during certain refreshes — sometimes the tables load, sometimes they fail.
• .NET & ODBC Connectors are already installed

Has anyone faced this kind of issue before? Could this be due to:

• Network instability?

• Timeout settings?

• Server-side MySQL configurations?

These are the errors, when I run a full refresh

It occurs when I run each tables individually.

NB: These refresh was working till last week.

Any advice or troubleshooting suggestions would be really helpful.

Thanks in advance!