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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |