Forum Discussion
Value.NativeQuery bypass Query Folding?
Value.NativeQuery is a query written in the source's native language, which is what query folding does with M code. There is no need for query folding on a NativeQuery, because it already is a Native Query.
--Nate
Anonymous
Thank you for your confirmation that Query Folding does not occur for the transformation step with Value.NativeQuery since the query included in Value.NativeQuery already is a native query. This really wasn't explicitelly stated anywhere, however there were indications that is how it works.
Note:
I was confused when I heart or read that if the "View Native Query" option (in Applied Steps) remains enabled then the Query Folding occurs for that transformation step, which is not true in case of M function Value.NativeQuery as you clarified.