Forum Discussion
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." ...
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
Hi nfiorilla,
You can direct add these additional parameter string in advanced option or edit in query editor.
Power BI Tips for Working with MySQL
Regards,
Xiaoxin Sheng
Hi Anonymous,
I resolve this issue setting the parameters in the my.cnf of MySQL Server.
Thanks.