Redshift with DATEDIFF Function Throws Expression.Error

[willayd]

When using the Redshift connector with DirectQuery and the DATEDIFF function I receive the following error:

Release:
April 2020

Product Version:
2.80.5803.1061 (20.04) (x64)

Error Message:
OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression..

This may or may not be related to a more general issue described here:

https://community.powerbi.com/t5/Issues/OLE-DB-or-ODBC-Error-Expression-Error-We-couldn-t-fold-the/i...

[v-chuncz-msft]

@willayd 

To get faster and better technical support for this issue, you may directly create a support ticket.