Video unavailable
SQLBits 2022
Error handling like a pro in Power Query
Topics: Catch errors, filter out wrong data + files and create Error reports.
How do you prevent unexpected data or incorrect files from blocking your dataset refresh?
In this session you will learn what options you have to make your Power Query ETL more robust, such as:
○ catch errors with try otherwise and error details
○ filtering out and logging invalid files
○ filtering and logging incorrect rows
○ Creating error reports