Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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/