cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dutifuldax
Helper III
Helper III

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 

1 ACCEPTED SOLUTION
dutifuldax
Helper III
Helper III

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

View solution in original post

9 REPLIES 9
dutifuldax
Helper III
Helper III

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

View solution in original post

dutifuldax
Helper III
Helper III

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 

dutifuldax
Helper III
Helper III

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 

I can send you 66.8 if you want.

That would be great. How will you do that?

 

thanks

Send me a private message with your email.

lbendlin
Super User
Super User
lbendlin
Super User
Super User

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.

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

 

Thanks

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors