Error In Appended

[ffirda99]

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!

[MNedix · Accepted solution]

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.

[MNedix]

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.

[ffirda99]

Hi, @MNedix 

I used column quality & distribution, and I got an error column.

Now, I want to know how to show error detail? Or filter data error, how to do it? so I can fix the data.

Thank you