topic Is query folding in data flow related to user credentials access limitations? in Dataflow

Is query folding in data flow related to user credentials access limitations?

Anonymous — Fri, 29 Nov 2024 13:07:11 GMT

I am trying to replicate a Data flow which is created by another person to test out Increemental refresh. I observed that their query steps are folding and my steps are not folding. In general if query is not folding it means that we are unable apply transformations steps directly on the source. Iam referencing following articles.
https://learn.microsoft.com/en-us/power-query/query-folding-basics

Understanding query evaluation and query folding in Power Query - Power Query | Microsoft Learn

Query folding indicators in Power Query - Power Query | Microsoft Learn

Please let me know if the following queries makes sense as credentials might be different:
Is query folding in data flow related to user credentials access limitations?

Ref image: Fold/unfold

Re: Is query folding in data flow related to user credentials access limitations?

lbendlin — Fri, 29 Nov 2024 15:45:31 GMT

"Capitalized Each Word" is poison for folding. Don't do that.

Re: Is query folding in data flow related to user credentials access limitations?

Anonymous — Mon, 02 Dec 2024 01:20:20 GMT

HI Anonymous,

According to your description, it seems like your requirement is more related to Dataflow Gen2. I will help you move this to data factory forum to get further support.

Regards,

Xiaoxin Sheng