OLE DB or ODBC error (Fatal error while connection power bi with my SQL)

[Shivam_Kathpal]

Error Messge:
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] MySQL: Fatal error encountered during data read.. '.

Hi Community,
I am facing the above error while fetching the data from my sql.

Connection in ok and data is coming when I transform the data and bring the data for only 7-8 days, but when I try to fetch data from the same data source for more than 8 days, the above error is occurring, need your support to solve this error.

Thanks & Regards,
Shivam

[amitchandak]

@Shivam_Kathpal , In the home tab, go to transform data -> Edit Data source setting-> Clear permission

Make sure you have installed the latest .net driver https://dev.mysql.com/downloads/connector/net/

[Shivam_Kathpal]

Hi @amitchandak , thanks for the reply, but I have tried what you have said and then also we are facing the same problem, anything else that you can suggest.

Thanks & Regards,

Shivam Kathpal