M365Con 2027 – die kostenlose Online-Konferenz · 11–22 Jan 2027 · 120 sessions m365con.net

Power Platform dataflows

Produkt

Dataflows in Microsoft Power Platform use Power Query to ingest, transform and load data into Dataverse or other destinations, on demand or on a schedule.

◆ PRODUKTPower Platform dataflowsM365.FM
Titelbild: Power Platform dataflows (Produkt)

Beziehungen

Power Platform dataflows ist ein Produkt und Teil von Power Platform.

Beschreibung

Power Platform dataflows are a self-service, cloud-based data preparation technology in Microsoft Power Platform. They are built on Power Query and are used to ingest data from a source, transform it and load the result into a destination such as Microsoft Dataverse, a Power BI workspace or an organization's Azure Data Lake Storage account. Dataflows are part of Power Platform and can run on demand or on a schedule.

The main purpose of a dataflow is to keep transformation logic in one central place, separate from the modeling and visualization layer in Power BI. Because the prepared tables are stored centrally, several solutions can reuse them instead of each report or app repeating the same Power Query code. Other services read the results through Dataverse, the dataflow connector or the data lake. According to Microsoft Learn, these consumers include Power BI, Power Apps, Power Automate and Dynamics 365 applications.

In terms of sources, the documentation lists more than 80 supported data sources. Sources that sit on premises require an on-premises data gateway. The transformation step uses the Power Query experience, which means that data shaping tasks such as cleaning, combining and reshaping tables are defined in the same query language used elsewhere in the Microsoft data stack.

Typical scenarios named in the documentation include migrating legacy data into Dataverse, replacing ETL tooling when building a data warehouse or star schema, and avoiding duplicated Power Query code across reports. Dataflows are therefore relevant both for application builders who need data in Dataverse and for analytics teams who want a shared, reusable preparation layer.

On licensing, no dataflow-specific license is required. The feature is covered by the licensing of Power Apps, Power BI or Dynamics 365 Customer Insights. Microsoft Learn also notes a generation distinction on the Power BI side: Power BI dataflow Gen1 is described as legacy and receives no new features, while Gen2 is recommended for Premium customers with Fabric access.

The M365.FM episode "Migrate Dataverse Data Between Environments Safely" lists Power Platform Dataflows among several migration paths for Dataverse data, alongside the Dataverse Migration Utility, Azure Data Factory and third-party ETL solutions. The episode says the right path depends on scale and complexity, and that complex data types and relationships such as option sets, lookups, polymorphic lookups and hierarchies require careful mapping to preserve integrity and behavior.

The episode "Power Apps Code Apps - Simply Explained" mentions dataflows in the context of connecting Power Apps Code Apps with other services. It names Power Automate cloud flows for synchronizing data and Power Platform dataflows for data management across environments as examples of such integrations. Taken together, the episodes position dataflows as one data movement and preparation option within the wider Power Platform, used next to Dataverse, Power Automate and other tools rather than as a replacement for them.

Überblick, mit KI aus M365.FM-Folgen und den Fakten dieser Seite zusammengestellt. Du kannst ihn unten über „Bearbeiten“ verbessern.

TypProdukt
DokumentationPower Platform dataflows – Microsoft Learn learn.microsoft.com

Diese Kurzbeschreibung gibt es noch nicht in deiner Sprache – gern ergänzen.

Verwandte Themen kurz erklärt

Mit Power Platform dataflows verknüpfte Themen, jeweils kurz erklärt:

Alle Beziehungen von Power Platform dataflows, nach Art der Beziehung geordnet:

Teil von

Angebote, zu denen Power Platform dataflows gehört:

Glossar

Community-Wiki

Oben die Kurzinfo, unten das Wissen der Community: ergänze praktische Tipps, Beispiele oder Korrekturen. Neue Beiträge werden zuerst geprüft, bewährte Mitglieder veröffentlichen direkt.

Experten und Firmen zu diesem Thema

Dieses Thema hat noch niemand im Profil angegeben. Trag es in deinem Profil ein.

Experten zu verwandten Themen

Expertinnen und Experten zu Themen, die mit Power Platform dataflows verwandt sind, jeweils mit dem verbindenden Thema:

Quellen

Gepflegt von Mirko Peters (Microsoft MVP) · Zuletzt aktualisiert: