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
v-priyankata's avatar
v-priyankata
Icon for Community Support rankCommunity Support
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.

  • v-priyankata's avatar
    v-priyankata
    Icon for Community Support rankCommunity Support
    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.

     

    • v-priyankata's avatar
      v-priyankata
      Icon for Community Support rankCommunity Support
      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.

       

      • v-priyankata's avatar
        v-priyankata
        Icon for Community Support rankCommunity Support
        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.