Dataflow
A Power Query-based ETL pipeline that ingests and transforms data into Dataverse on a schedule.
A dataflow in the Power Platform is a Power Query-based ETL pipeline that ingests data from a source (SQL, SharePoint, Excel, CSV, API, another database), transforms it through Power Query M expressions, and lands it in Dataverse on a scheduled refresh. Dataflows are how citizen developers build data integration without coding — drag-and-drop transformations, declarative joins, type coercion, merging multiple sources into a unified shape. Output can be standard dataflows (writing into Dataverse tables) or analytical dataflows (writing into Power BI semantic models or Azure Data Lake). For Dynamics 365 integrations involving moderate data volumes and configurable transformations, dataflows are often a simpler answer than custom code or full ADF pipelines.