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

I gave this presentation at the Dutch Power BI Gebruikersdag 2020 (PBIG).

Slides + demo files:
https://arthurgraus-my.sharepoint.com/:u:/g/personal/agmgraus_arthurgraus_nl/EWjNQUoDgPNImrIt9gdKkZsBDnzCvbXCjnrT8N05RIOuNQ?e=Vg6nro