Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
158
Views
Topic starter
Hi, all. New to the forum and really appreciate all the expertise here. I have a "dataformat.error" on a date column but the error is beyond the first 1,000 rows in the query editor. Is there a best practice to finding this error location, fixing, and then returning to the whole data set in editor? Thanks for any help provided.
Posted : 25/05/2020 10:06 am
Hi Paul,
Add a step with Keep Rows with errors, this way you'll have them all on screen. After you identify the errors, you can just remove the Keep Errors step to return to your original data set.
Posted : 25/05/2020 10:57 am
