Implementing error checks in Power Query

Allowing incorrect data to appear in a report can diminish trust in your organisation’s reporting capability. To avoid incorrect data appearing in the first place, we can force refresh errors when certain business rules aren’t met (since usually stale data is better than incorrect data). In this post, I demonstrate a pattern for applying custom error messages when business rules are violated. These messages can be set up to provide error details that cut down troubleshooting time.