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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
DrBiker
Advocate II
Advocate II

Redshift and data folding error

I am using a redshift database, and I can connect to that OK in Power BI Desktop.  My problem comes when I try to use some calculated fields; I have simplified some down to try and find the error so for example:

     Measure 2 = COUNT(evhc[flag]) 

 

Where flag is an integer.  This give the error:

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

 

I assume that when folding this query that Power BI is using SQL syntax rather than Redshift?

 

Is this a bug or am I missing something?

 

p.s. I know I can do this without using a measure, but this is a test as my measures are more complex than this.

 

 

1 ACCEPTED SOLUTION
pqian
Microsoft Employee
Microsoft Employee

@DrBiker I'm assuming you are connecting to RedShift in DirectQuery mode. This error is thrown when some aggregation (in this case the count) is been translated to M for execution, so it's not really SQL yet. 

 

I think this is related to a bug that we know about, is [flag] a nullable column? Counting on nullable column wasn't working in the preview bits, we will be fixing it in the next release.

View solution in original post

5 REPLIES 5
WaqasP
Regular Visitor

Has this been resolved?

pqian
Microsoft Employee
Microsoft Employee

@DrBiker I'm assuming you are connecting to RedShift in DirectQuery mode. This error is thrown when some aggregation (in this case the count) is been translated to M for execution, so it's not really SQL yet. 

 

I think this is related to a bug that we know about, is [flag] a nullable column? Counting on nullable column wasn't working in the preview bits, we will be fixing it in the next release.

arify
Microsoft Employee
Microsoft Employee

@pqian is right, this should be fixed in the next release (~end of august). Thanks

Hi,

 

I am getting the same error message (although different DAX formula!!!

 

Is this fixed or not?

 

Thank you!

MattAllington
Community Champion
Community Champion

Redshift is in preview mode, so I guess it is a bug.    Send a frown using the desktop frown so the developers can look at it.



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors