MySQL Error in Scheduled Data Update

[nfiorilla]

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."

Is it possible to set MySQL net connector, that gateway uses, parameters to avoid this error?

Thanks!

[Anonymous]

Have you tried updating the On-Premise Data Gateway to the latest version?  I'm wondering if the project has been updated to a newer engine but the gateway has fallen behind?

[nfiorilla]

Hi @Anonymous,

It is a new setup. I downloaded the data gateway yesterday.

thanks!

[Anonymous]

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?

[nfiorilla]

@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.

[Anonymous]

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?"

[nfiorilla]

I installed the same MySQL Net Connector in both servers. And I'm trying to compare mysql server configuration now.

[nfiorilla · Accepted solution]

I found this as a soluction

set net_write_timeout=99999; set net_read_timeout=99999

 but 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

[v-shex-msft]

Hi @nfiorilla,

You can direct add these additional parameter string in advanced option or edit in query editor.

MySQL.Database

Power BI Tips for Working with MySQL

Regards,

Xiaoxin Sheng

[nfiorilla]

Hi @v-shex-msft,

I resolve this issue setting the parameters in the my.cnf of MySQL Server.

Thanks.