Use try .. otherwise to trap and deal with errors in Power Query. Download the Excel file here: https://www.myonlinetraininghub.com/i...

00:18 Introduction to try .. otherwise
01:08 Using Remove Errors and Replace Errors
01:33 Using try to Check for Errors
01:50 Examining the Contents of Error Records
03:20 A Fast Way to Access Error Contents Using try
04:54 Using try .. otherwise to Replace Calculation Errors With a Default Value
06:02 Dealing With Errors Caused by a Missing Data Source

View my comprehensive courses: https://www.myonlinetraininghub.com/

Connect with me on LinkedIn:   / myndatreacy