Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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.
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.
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.
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