Forum Discussion
Date column Error Power Query Editor
Hi amitchandak
I changed to text, however the error at the bottom is still left. It still looks like this, and I suspect this error unables me to filter on the date column and then load to table in Excel (?)
the code is the following when having removed errors and changed to text, and still getting the last row of Error.
;#"Changed Type1" = Table.TransformColumnTypes(#"Removed Errors",{{"DeliveryDate", type text}}),
; #"Filtered Rows2" = Table.SelectRows(#"Changed Type1", each ([DeliveryDate] = "11/10/2020 9:07:31 AM"))
;
Thankful for any further help!
;
Microsoft EmployeeSince you have an error across the whole row, something other than your date type error is going on. You will need to filter (or change) that row before the steps when it changes to all errors. Is there a step w/o errors? Which steps causes them?
Regards,
Pat
Thanks for reply! Is there a way to identify which row number this has in the original CSV-file? I can only find it in Power Query Editor when I filter like above and the error row is not row number 2 in the CSV-file for sure
- mahoneypat
I would keep all your columns as text and load that table, so you look at all the data in the Data View (pull down each column header and see all the values in each column). I'm guessing one will stand out, and that the one to filter out before you do your change type steps. Or you could look at the starting csv file in Excel to do same.
Pat