Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

OLE DB or ODBC error: [DataSource.Error] MySQL: Fatal error encountered during data read

Hello, 

 

In the past week i've gotten the above error message for all my reports when I try to refresh my reports. Each of the reports with this error is attempting to pull data from a mysql server, connected via VPN. 

 

I looked through other posts with this error and tried to play around with the data in power query: checking for incorrect data type or oddities in the steps, but nothing has helped. 

 

I also think this is unlikely to be the issue because the error is with three different reports. I am also able to refresh in the gateway, bypassing the desktop without any issues. 

 

Does anyone have any ideas of where else i might be able to look to deal with this problem?

 

Thanks 

Dataflow
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Found a solution to this... It was to do with the permissions. Clearing all data source permissions (File-->Options and Settings --> Data Source Settings --> clear each data source permission). 

     

    Doing this for both local and global permissions and reentering credentials when refreshing fixed the issue

9 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    This is broken since about March. We have a ticket open with Microsoft  but they blame it on MySQL.  MySQL are looking into it, but not really with urgency. Our workaround is to use an older gateway version (66.8 for example) just for the MySQL connections.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks very much. Do you know where it is possible to download older versions of the gateway?

       

      Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi, 

     

    I rolled back to version 72.6 of the gateway (took over the existing gateway when installing) but it still has the same error. 

     

    Any other advice? do i need to go to an earlier version of the gateway and if so where can i find that?

     

    Thanks 

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        That would be great. How will you do that?

         

        thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

     

    Unfortunately i've rolled all the way back and this stil hasn't fixed the issue. 

     

    I was able to load with the most up to date gateway for a couple of weeks before this happened, so maybe it isn't a gateway issue? 

     

    Anyone else resolved this issue?

    Thanks 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Found a solution to this... It was to do with the permissions. Clearing all data source permissions (File-->Options and Settings --> Data Source Settings --> clear each data source permission). 

     

    Doing this for both local and global permissions and reentering credentials when refreshing fixed the issue