Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Redshift with DATEDIFF Function Throws Expression.Error

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

Status: New
Comments
v-chuncz-msft
Community Support

@willayd 

 

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