Forum Discussion

Suryamaxillian's avatar
Suryamaxillian
Regular Visitor
1 year ago
Solved

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 D...
Need Help
  • Suryamaxillian's avatar
    Suryamaxillian
    10 months ago

    Hi Anonymous and v-ssriganesh ,

    Issue is resolved now. I just tried re-configuring the MySQL Installer Community.

    Thank you

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Suryamaxillian 

Thank you for reaching out to the Microsoft Fabric Forum Community.

amitchandak Thanks for the inputs.


Check the MySQL logs to see if there are any clues about why connections are failing. try bumping up the timeout settings so Power BI doesn’t lose connection during long data loads.

Make sure you're using the latest version of the MySQL ODBC driver it can fix bugs and improve stability. Schema changes - Double-check if any tables or columns were changed or removed in MySQL that could break your Power BI queries.

Thnaks.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Suryamaxillian 

I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Suryamaxillian 

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Suryamaxillian 

      Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted. if you have any other issues please reach community.

       

      • Suryamaxillian's avatar
        Suryamaxillian
        Regular Visitor
        1 year ago

        Hi Anonymous,

        Thank you for following up. I don’t have direct access to the MySQL environment, so I’ve shared your suggestion with the relevant team who manages the database. I’ll update here once I hear back from them or if I need further assistance.