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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
JessieF
Advocate II
Advocate II

Help me understand why one dataflow query folds and other does not

Hello Community,

 

I have a dataflow with a few tables, using Native query connection and I'm having an issue with a couple of tables that I expect should fold and be available as query views for Direct query consumption, but they are not storing that way.
I have Enhanced compute engine settings turned on and a refresh operation was performed. 


I have several other dataflows with tables with similar design, just from other source tables -- selecting specific columns, applying simple where clause and all of them are folding for query views.  It's only these couple tables in this particular dataflow with issue.

 

How can we fix this so the table can be in a query view?

 

I intended for this to be consumed as direct query.
The third query is also not folding, and is set up exactly like the one in Query2, but the where clause is <>"US" - but we're experiencing the same problem.


query folding issue.png

1 REPLY 1
AnkitKukreja
Super User
Super User

Hi! @JessieF 

 

You should have a look at the doc to understand how it works and if you are missing anything.

 

https://learn.microsoft.com/en-us/power-query/query-folding-basics

https://www.mssqltips.com/sqlservertip/3635/query-folding-in-power-query-to-improve-performance/

 

 

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
https://topmate.io/ankit_kukreja

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Top Solution Authors
Top Kudoed Authors