Forum Discussion
MySQL Error in Scheduled Data Update
- 8 years ago
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
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?
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.