Forum Discussion

sabedin's avatar
sabedin
Helper I
8 years ago

Redshift Direct Query - almost nothing works!

Hello,

 

I have connected Power BI Desktop to Amazon Redshift in Direct Query mode. The following error appears when I write a simple Calculate formula, or even when I use a column as a Visual Level Filter!!!

 

 

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

 

It looks like a bug to me!

 

Anyone else having this issue? Any suggestion what to do?

 

Thank you

Sabedin

Need Help

3 Replies

    • sabedin's avatar
      sabedin
      Helper I
      8 years ago

      Hi,

       

      I have Power BI installed from Windows store, so definitely that is not the problem. 

       

      Will create a ticket though.

       

      Thanks

    • sabedin's avatar
      sabedin
      Helper I
      8 years ago

      I cannot create a support ticket, it takes me to login Window and when I login it sends me to my Power BI Service Account. Then from here when I go Help & Support >> Help, it sends me back to help page, BUT LOGGED OUT, and so everything start over. DEADLOCK.

       

      Can you help me on this?

       

      Thanks