Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
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/