Skip to Content

Fabric Dataflows

Version 2.1 by Dimitri Rupp on 2026/06/11 09:16
Warning
For security reasons, the document is displayed in restricted mode as it is not the current version. There may be differences and errors due to this.
On this page

Fabric Dataflows

Information

What: Dataflows Gen2 — modern, scalable ETL via Power Query in Fabric.
Strength: No-/low-code, native Lakehouse integration, incremental refresh.

What are Dataflows Gen2?

Dataflows Gen2 are a modern, scalable way to ingest, transform, and load data into Microsoft Fabric. They allow users to build reusable ETL pipelines using familiar Power Query experiences, while integrating natively with Lakehouse, Warehouse, and other Fabric destinations.

🔑 Key Features

FeatureWhat it gives you
Power Query InterfaceBuild transformations using a no-code or low-code experience, with full support for M language.
Direct Lakehouse IntegrationWrite output directly to Lakehouse tables in Parquet format, enabling seamless analytics and reporting.
Incremental RefreshFilter out previously processed data — only new or changed rows are loaded on each refresh.

🧩 Common Use Cases

  • Loading structured data from SharePoint into Lakehouse
  • Transforming Excel-based reports into analytics-ready formats
  • Filtering and deduplicating data before ingestion
  • Automating daily refreshes for operational dashboards

Dataflow Gen2 vs. Pipelines vs. Notebooks

Orchestration typeStrengthWhen to use
Dataflow Gen2Power-Query-Low-Code; Lakehouse-nativeStrukturierte Ingestion aus SharePoint/Excel/APIs, einfache Transformationen
Data PipelineNative Fabric copy + transform; parametrierbarStandard-DB-zu-Lakehouse-Bewegung, getriggerte Workflows
NotebookPySpark / Python — volle KontrolleCustom-Logik, ML, komplexe File-Parsing, Spezialfaelle
flowchart LR
    SP[SharePoint Files / Lists] -->|Power Query| DF[Dataflow Gen2
M-language]
    XLS[Excel Reports] --> DF
    API[REST API / Board] --> DF
    DF -->|Parquet| LH[(Lakehouse
Bronze / Silver)]
    DF -->|incremental refresh| LH

    classDef src fill:#e3f2fd,stroke:#1976d2,stroke-width:1px
    classDef df fill:#fff3cd,stroke:#b85c00,stroke-width:1px
    classDef lh fill:#f4a261,stroke:#b85c00,stroke-width:1px,color:#000
    class SP,XLS,API src
    class DF df
    class LH lh

Real-world examples in SPL

Related pages

Information

Migration footer
Source: Fabric Dataflows (SharePoint)
Original author: Bukkerji Sreejith
Original last-modified: 2025-10-23
Migration date: 2026-05-24
Migrated by: Dimitri Rupp via ClaudeAI
Notes: EN-Original-Texte 1:1 (What Are/Key Features/Use Cases); dekorative Image-Webparts ausgelassen; Vergleichstabelle Dataflow/Pipeline/Notebook + Mermaid + SPL-Beispiele als Wissensbasis-Erweiterung.

Verwandte Themen

Kuratiert — kann direkt im Editor ergänzt werden://

Failed to execute the [velocity] macro. Cause: [The execution of the [velocity] script macro is not allowed in [xwiki:IT-Wiki.Makros.Verwandte-Themen.WebHome]. Check the rights of its last author or the parameters if it's rendered from another script.]. Click on this message for details.

Status: Migriert — Team-Review ausstehend · Owner: (festlegen) · Letzter Review: 2026-06-11