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

[JessieF]

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.

[AnkitKukreja]

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/