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."

Is it possible to set MySQL net connector, that gateway uses, parameters to avoid this error?

Thanks!

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

      Hi Anonymous,

       

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

      thanks!

      • Anonymous's avatar
        Anonymous
        Not applicable

        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?