22-25 April 2026

Bulletproof Your Dataflows: Error Handling and Data Quality in Fabric

Proposed session for SQLBits 2026

TL; DR

Learn how to build resilient Dataflows Gen2 pipelines with proactive error handling and data quality checks. Explore try/otherwise, structured error outputs, custom messages, partial failure patterns, and centralized logging for reliable monitoring

Session Details

Modern data solutions depend on reliable pipelines, yet error handling and data quality checks are often overlooked until failures occur in production. This session dives deep into building resilient Dataflows Gen2 solutions leveraging try/otherwise, structured error outputs, custom error messages, and partial failure patterns, centralizing error logs in dedicated tables for downstream monitoring.

3 things you'll get out of this session

Practical techniques to implement robust error handling and data quality checks in Dataflows Gen2. Patterns for partial failures, structured error outputs, and custom notifications to prevent pipeline breakdowns. Methods to centralize error logging for effective monitoring and faster troubleshooting.