Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
84 | |
70 |