Forum Discussion

nfiorilla's avatar
nfiorilla
Regular Visitor
8 years ago
Solved

MySQL Error in Scheduled Data Update

Hi, I have a MySQL database, were I take data for my reports. I have schedule the data update but the gateway always fail with the following error:"MySQL: Fatal error encountered during data read." ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Have you tried updating the On-Premise Data Gateway to the latest version?  I'm wondering if the project has been updated to a newer engine but the gateway has fallen behind?

  • nfiorilla's avatar
    nfiorilla
    Regular Visitor
    8 years ago

    Hi Anonymous,

     

    It is a new setup. I downloaded the data gateway yesterday.

    thanks!

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Kick off a refresh using your PBIX file and the Power BI Desktop.  Do you get an error there also?

       

      Did you need to load any MYSQL drivers onto your On-Premise data gateway server?  Could those differ from the ones on your local machine using Power BI Desktop?

      • nfiorilla's avatar
        nfiorilla
        Regular Visitor
        8 years ago

        Anonymous, it takes a lot of time, compare to the developer server but it finally update.
        Can I set with mysql driver use in the data gateway?
        I have set a power bi trial point to the developer server and it works ok. But both server have the same mysql version. They have differents windows.