One thing to mention is that you could’ve manually gone through your original query, select the fields that you want to audit and select the option called “Keep Errors” so you can only see the errors found in those specific fields/columns:įrom my experience over the years, there are only a handful of errors that you’ll encounter in Power Query. You can click in the whitespace next to the value errors to see the Error Message in the Cell Preview pane as shown below. Clicking that hyperlink will make Power Query automatically create another query, usually with the Format “Errors in ”, with only the rows that had errors in your original query and it’ll also add an Index Column (called Row Number) to tell you exactly in what row the error happened. If Power Query doesn’t give you that button, or it doesn’t get you to the first step where you error was raised then it is helpful to navigate through the steps to find out where the error first appeared.įor Value Level errors the hyperlink to the errors is an invaluable help. In some cases Power Query even gives us this “Go To Error” button so we can go to the first step where we hit the error so we can fix the issue. The best way to audit the errors is to go into the Power Query editor window (fka Query Editor window) and go through the steps and values to read the error messages.įor both categories or types of errors, it is extremely important to understand the Error Message which provides a path (exactly where it happened, usually the first sentence in the error message) and checking the Error Reason (exactly why it happened, usually in the details section of the error message).Īn example of a Step level error with its Error message is shown in the next image: For example, you could click on the “1 error” hyperlink shown in the image below and Power Query will create a new query with only the rows that have errors so you can audit those rows specifically. Value Level Errors – query will load, but will have a warning saying that it loaded with errors and give you a hyperlink to see what errors it had when loading.Step level Errors – it’s main symptom is that you query simply will not load giving you a message similar to the one below.Power Query primarily handles 2 types or categories of errors: As any other programming language, Power Query handles errors in its own unique way and the goal of this blog post is to give you a few hints on how to audit the errors or warnings that Power Query might throw your way.
0 kommentar(er)
