MySQL: Fatal error encountered during data read. .

Hi Everyone,
Please can someone help out?

I have an existing dashboard that refreshes on an hourly basis. Our data source is MySQL which is an OLTP database.  The dashboard has been working fine until recently (last week) when it started failing with this error message on the service;

Error Message: 

"Before the data import for finished, its data source timed out. Double-check whether that data source can process import queries and if it can, try again."

I thought it was an issue with the data Load capacity. I went to the Desktop to refresh and realized that my data load takes forever before timing out. So, it keeps showing "Waiting for the DB/Table_name" before timing out. I went to the power query side to see what the issue was.  I could connect to the MySQL database and preview the data. Filter the data table with other columns but not the DateTime column. When I try filtering the table using the Datetime column, this message will show at the bottom right of the query editor panel "Waiting for the DB/Table_name" and after a while, it will bring out a Fatal error message (from the image).
I tried connecting to other tables from other MySQL databases, and everything looks okay. I could filter the table using the DateTime column easily. Please, why am I having an issue with this particular database and table?

I checked, and we are using the latest gateway and power bi version. I have also increased the Maximum memory used per simultaneous evaluation on the Data Load option. The issue still persists. 

Datasource: MySQL database:

grey vijay Please help me out on this☹️