bigint datatype not working in directquery mode in mysql db

[navinrangar]

i have a mysql database on local. 

i have imported table from my database through directquery mode. all the columns are working fine in the table. however columns which are given BIGINT data type in my MySQL database are not being loaded in powerbi. 

with import mode, it is working fine, but in directquery mode, this error message is being displayed. 

[v-xiaoyan-msft]

Hi @navinrangar ,

Did you create a dataflow using this data source?

We have the acknowledged issue about "We couldn't fold the expression to the data source. Please try a simpler expression".

The product team have been aware of the issue and the engineers will do their best to resolve it. I will update here if there is any progress, so please be patient. 

Best regards.
Community Support Team_ Caitlyn

[navinrangar]

@v-xiaoyan-msft Thanks for your response.

Actually, i connected AWS mySQL database with DirectQuery on my PBI desktop. data is loaded and working properly in import mode. however, in directquery mode, BIGINT datatype columns are couldn't be queried. and the error occuring.