Forum Discussion
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!
I found this as a soluction
set net_write_timeout=99999; set net_read_timeout=99999but it`s impossible to set that variables to the gateway or power bi desktop.
https://stackoverflow.com/questions/2546115/mysql-exception-fatal-error-encountered-during-data-read
9 Replies
- AnonymousNot 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?
- nfiorillaRegular Visitor
Hi Anonymous,
It is a new setup. I downloaded the data gateway yesterday.
thanks!- AnonymousNot 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?