Forum Discussion
MySQL Error in Scheduled Data Update
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
I installed the same MySQL Net Connector in both servers. And I'm trying to compare mysql server configuration now.
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.