Putting it all together

Throughout this chapter, you have gained insights into various aspects of error handling in Power Query. You have learned about the nature of errors, how to raise them intentionally, as well as how errors are contained, detected, and ultimately handled. With this foundational knowledge in hand, it is time to consolidate your learning by delving into two practical examples that showcase real-world scenarios of error handling in action. These examples will provide a deeper understanding of how to prevent errors, make deliberate choices, and address errors when they arise.

Feel free to design your own approach to these scenarios before diving into them. If you are not comfortable translating that into M code, that is absolutely fine. You can still create an outline and think of obstacles that have to be overcome. This will allow you to compare your strategy to the one suggested here. But remember, there are a multitude of solutions to any given problem, and...