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
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.
When the Data Gateway is called as part of the refresh, the gateway server itself does the work. This is why the drivers that are installed are important. You are correct that it being a different operating system will mean its drivers will differ slightly which isn't what i'm pointing to.
What i'm concerned with are elements such as whether its a 64-Bit driver. Whether its the same driver (ignore OS differences). Things like this. We want to think about it like this: "If you were to run Power BI Desktop on the server and do a refresh, would it work? If it doesn't work, what would you need to do to get it working?"
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