Forum Discussion
Error In Appended
Hi,
I struggle when I want to find out something wrong with my column in my Appended Table, there is no information on which columns are errors.
May I know, how to filter column which has error data? Thank you for helping!
This article may be helpful - https://learn.microsoft.com/en-us/power-query/dealing-with-errors
If this solved your problem then please mark it as the solution so others can see it.
3 Replies
Hi,
I think if you scroll to the right through the columns, the header of the Column(s) with errors will be in Red. It would also help to activate Column quality and Column distribution in the View section of Power Query.
This article may be helpful - https://learn.microsoft.com/en-us/power-query/dealing-with-errors
If this solved your problem then please mark it as the solution so others can see it.
