Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Date column Error Power Query Editor

Hi, I have a CSV-file with a date column that contains some values that are not recognized as date, and hence show as Error in the Power Query Editor. I have chosen to remove Errors but still end up...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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! 

    ;

    • mahoneypat's avatar
      mahoneypat
      Microsoft Employee
      5 years ago

      Since 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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