Power query errors: Detect, prevent & fix them

Power Query is an amazing tool to manipulate, reshape and change data however managing & fixing errors can be challenging in the app. Something as simple as changing case of a column name can cause it to break.

Sometimes errors appear on load, other times the entire query breaks or they could come from the data source. I cover in this video the different types of errors, how to detect & fix them and good practice to avoid making errors.

I cover all different kinds of errors at various points of the video:
0:00 - Introduction
0:49 - Errors in cells
5:41 - Errors in query steps
7:27 - Errors in precedent queries
11:13 - Data source errors
14:06 - Relationship errors
15:25 - Transformations to avoid (as they often break)

Видео Power query errors: Detect, prevent & fix them канала David Benaim