Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
svickers
Regular Visitor

Snowflake DirectQuery can not fold query.

‎08-03-2020 07:19 AM

I am attempting to connect to our Snowflake db for the first time with Power BI and two simple tables.  One table works fine, I can put dimensions and measures into a graph and it properly aggregates things without complaing.  My other table however I can display single lists of text fine, but as soon as I add a measure it gives 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've tried reducing the table down to just two columns by removing the others in the interface, but still has the same problem any time I want to aggregate anything.  I am on version 2.83.5894.961 and also updated to the lastest Snowflake ODBC drivers... What am I missing?  

Screenshot_1201.png

Screenshot_1202.png

 

 

Labels:
Message 1 of 6
2,458 Views
0
5 REPLIES 5
JChai
Advocate I
Advocate I

‎04-07-2025 12:23 PM

Is 2025~ I need help! Any advice will be great.

Message 6 of 6
728 Views
0
Anonymous
Not applicable

‎06-15-2021 12:03 PM

@svickers  Did you sort out this  ?

Message 5 of 6
1,765 Views
0
svickers
Regular Visitor

‎08-08-2020 10:57 AM

Bumping to see if anybody has any ideas....

Message 4 of 6
2,354 Views
0
parry2k
Super User
Super User

‎08-03-2020 07:21 AM

@svickers are you using native snowflake drive to connected to snowflake. Get data -> Snowflake

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 2 of 6
2,456 Views
0
svickers
Regular Visitor
In response to parry2k

‎08-03-2020 07:34 AM

@parry2k Yes, using the native method.

Message 3 of 6
2,440 Views
0

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All