OLE DB or ODBC Error: Fatal Error Encountered During Data Read in Power BI

[AustinBazaar]

Hello,

I am encountering an issue in Power BI when attempting to save modifications to the server for my MySQL database. The error messages displayed are:

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] MySQL: Fatal error encountered during data read.'

This error appears for test tables, as shown in the attached screenshot:

           -austinba_veeqodbuat test_revenue_01

I have verified that the database connection is active, and the queries execute without issues in MySQL Workbench. The problem only occurs within Power BI.

Could anyone please help me understand why this error is occurring and how to resolve it? Any suggestions or troubleshooting steps would be greatly appreciated.

Thank you!

[v-pagayam-msft]

Hi @AustinBazaar ,
We haven't heard back from you regarding our last response and wanted to check if your issue has been resolved. If our response addressed your query, please mark it as Accept as Solution and click Yes if you found it helpful.If you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @AustinBazaar ,
We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.If our answer resolved your query, please consider marking it as "Accept as Solution" and select "Yes" if it was helpful. If needed any further assistance, feel free to reach out.

Thank you for being a valued member of the Microsoft Fabric Community Forum!

Regards,
Pallavi.

[v-pagayam-msft]

Hi @AustinBazaar ,

Thank you for the helpful response @nilendraFabric .As Niledra suggested, have you got an opportunity to review the information provided.In addition to that try updating the ODBC driver or MySQL connector that may help resolve compatibility issues.
Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Regards,
Pallavi.

[nilendraFabric · Accepted solution]

Hi @AustinBazaar 

Screenshot is not visible.
I am thinking this might be because of timeout issue , when PowerBI try connecting to database.
SET net_read_timeout = 99999;
SET net_write_timeout = 99999;

Run these once oon Mysql server and try connecting

On PowerBI try these :

• Clear cached permissions:
  • Go to File > Options and Settings > Data Source Settings.
  • Remove existing credentials for the MySQL source.
  • Reconnect and re-enter credentials
• Clear data load cache:
  • Navigate to File > Options > Data Load > Clear Cache.

Ensure that you are using the latest version of Power BI Desktop, as updates often fix compatibility issues

try wwitch from Direct Query mode to Import mode in Power BI if possible, as Import mode is less sensitive to connection interruptions ( for testing)

Please keep us posted if these are helpful.


Thanks