Enhancing Data Factory: Support for Nested ForEach Loops and Conditional Logic
Currently, in Data Factory, the ForEach activity does not support nesting, meaning you cannot place one ForEach loop inside another. This limitation makes it difficult to process complex, hierarchical data structures where an outer loop needs to iterate over a set of items, and an inner loop should perform additional processing for each item. Allowing nested ForEach loops would enable more flexible and scalable workflows, eliminating the need for workarounds like using multiple pipelines or flattening data before processing.
Additionally, conditional logic inside ForEach loops is another missing capability. Right now, if you need to execute certain logic only when a condition is met inside a loop, you must create separate activities outside the loop or use multiple pipelines. Enabling If activities inside ForEach loops or allowing ForEach loops inside If activities would improve efficiency by allowing more dynamic decision-making without extra pipelines or unnecessary complexity.
These enhancements would provide greater flexibility, reduce pipeline fragmentation, and simplify workflow design.
Recent ideas
Semantic model connection bindings should be in source control (Git)
Semantic model data source connection bindings should be source controlled. A semantic model can contain multiple data source references, each of which can be mapped to a separate Fabric data connec...frithjof_v3 hours agoCommunity ChampionNew10Views1like0CommentsBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal1401977 hours agoFrequent VisitorNew5Views0likes0CommentsAbout "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf17 hours agoFrequent VisitorNew48Views3likes2Comments