Video unavailable
SQLBits 2026
Fabric Dataflows Gen2 in Action: What Every Self-Service Developer Should Know
This session will guide you through how Power Query in Dataflows Gen2 in Fabric provides you with even more options, tools and integration with your enterprise setup:
- From Power Query in Desktop to Fabric Dataflows Gen 2
- Data Destinations greater reuse and share
- Dynamic Data Profiling & Error Handling
- Snapshots with Append to Lakehouse
- Don’t Break the Query Fold
- Query Plan & Performance Optimization
- Write SQL-Views with Visual Query Editor
- From Excel to SQL Analytics Endpoint in Lakehouse
- Orchestration Pipelines with invoke Dataflow Gen2
Get ready to understand the UI-first approach options we have in Fabric with Dataflows Gen2 for the self-service developer.
Self-service developers have Excel-files, SharePoint lists, Access databases, connecting to SQL database tables or views that IT maintains, multiple files, repetitive and manual tasks. Furthermore, self-service developers aren't skilled in writing T-SQL or Python - we need a UI-first approach, an easier solution based on our competence levels and Power Query is definitely that tool!
This session will guide you through how Power Query in Dataflows Gen2 in Fabric provides you with even more options, tools and integration with your enterprise setup:
- From Power Query in Desktop to Fabric Dataflows Gen 2
- Data Destinations greater reuse and share
- Dynamic Data Profiling & Error Handling
- Snapshots with Append to Lakehouse
- Don’t Break the Query Fold
- Query Plan & Performance Optimization
- Write SQL-Views with Visual Query Editor
- From Excel to SQL Analytics Endpoint in Lakehouse
- Orchestration Pipelines with invoke Dataflow Gen2
Look forward to understand the difference between Power Query, Dataflows in Power BI and Fabric.
Whether you're just starting or looking for that one extra trick to optimize your workflow, this session covers it all.
This session will guide you through how Power Query in Dataflows Gen2 in Fabric provides you with even more options, tools and integration with your enterprise setup:
- From Power Query in Desktop to Fabric Dataflows Gen 2
- Data Destinations greater reuse and share
- Dynamic Data Profiling & Error Handling
- Snapshots with Append to Lakehouse
- Don’t Break the Query Fold
- Query Plan & Performance Optimization
- Write SQL-Views with Visual Query Editor
- From Excel to SQL Analytics Endpoint in Lakehouse
- Orchestration Pipelines with invoke Dataflow Gen2
Look forward to understand the difference between Power Query, Dataflows in Power BI and Fabric.
Whether you're just starting or looking for that one extra trick to optimize your workflow, this session covers it all.