While we can’t cover every error, the purpose of this post is to help demystify some of the more common errors you are likely to encounter. Over time you will start to understand what the errors are and what causes them. Now that you’re working with Power Query, the error messages appear strange and unfamiliar and can be daunting at first. You’ve probably forgotten the first time you encountered the #NAME? or #VALUE! errors in Excel, but over time you hopefully worked out what to do when they arise. Just like Excel and other applications, Power Query has it’s own unique error messages. I’m sure you’ve not got this far without encountering your fair share of Power Query errors.
