Introduction to Dataflows Gen2
Acquisizione dei dati e modelli semantici con Microsoft Fabric
Alex Kuntz
Head of Cloud Curriculum, DataCamp
Dataflows Gen2 in Microsoft Fabric
What Are Dataflows Gen2?
- Tool for data transformation and ingestion
Key Features:
- Supports 300 plus Complex Transformations (e.g., merging, pivoting)
- Flexible schema options for dynamic customization
- Staging & Fast Copy: Handling large data volumes
- Seamless integration with Data Pipelines
Overview of the DataFlows Gen2 Interface
DataFlows Gen2 leverages Power Query Online for an intuitive transformation experience.
Dataflow Gen 2 Interface Components
Power Query Ribbon - Connect data sources and apply transformations
Queries Pane: Manage, rename, and enable staging for data sources.
Dataflow Gen 2 Interface Components
Diagram View: Visualize data sources and transformations
Data Preview Pane: Preview and interact with data
Dataflow Gen 2 Interface Components
- Query Settings Pane: Track and modify applied steps
Supported Data Destinations in DataFlows Gen2
Integrating Dataflows Gen2 in Data Pipelines
Why Integrate?
Perform further operations on transformed data and automate workflows
- Add Dataflows Gen2 as a pipeline activity.
- Ideal for additional operations on transformed data.
- Automate Dataflows within the pipeline.
- Monitor performance in real-time.
