You are building analytics pipelines for a reporting layer that serves dashboards, certified datasets, and downstream semantic models. The team needs a clear rule for where upstream transformations should live, inside Power BI dataflows or in an external ETL layer. The goal is to keep refreshes reliable, models reusable, and maintenance manageable.
When would you use dataflows versus external ETL for upstream transformations?