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
Hi Anonymous,
It is a new setup. I downloaded the data gateway yesterday.
thanks!
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.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.