Error Handling (like Try-Catch in SQL)

Hi Anonymous ,

To do this at the code level in M, you use the try...otherwise structure e.g.

try [Value] / 10 otherwise null

To do this at the whole query level you can try these methods:

Ensure columns always present:

https://blog.crossjoin.co.uk/2015/07/03/ensuring-columns-are-always-present-in-a-table-returned-by-power-query/ 

Handle source qury errors:

https://blog.crossjoin.co.uk/2014/09/18/handling-data-source-errors-in-power-query/ 

Make sure to read the comments after each of these blogs carefully, as other users add crucial amendments to the original code.

Pete