DataFormat.Error, DateTime value (Import, Append, Split, Merge Columns) Power Query - Ideas Feature

DataFormat.Error, DateTime value (Import, Append, Split, Merge Columns) Power Query - Ideas Feature
Download Data: data.gov.uk/dataset/27bc1dc6-...
Import and Append Data via Power Query from Multiple Excel Workbooks
SOLVED - DataFormat.Error: We couldn't parse the input provided as a DateTime value.
Split Columns, Change Format, Merge Columns
Ideas Feature
Facebook Page: / excelbasement
Facebook Group: / excelbasement
LinkedIn Page: / 28868635
Twitter: / excelbasement
Instagram: / excelbasementpvtltd

[@jaimetabilo484]

I was spending so much time trying to fix this!

[@wahajghauri6675]

Great Tip , Exactly the Same Approach that i used ! 👍

[@ExcelBasement]

Glad to hear it!

[@geetanjalimamgain1078]

Very helpful sir

[@ExcelBasement]

Thanks and welcome

[@bhawanarai510]

So helpful!

[@ExcelBasement]

Glad it was helpful!

[@evsonjunior8556]

Thank you so much!!!

[@ExcelBasement]

You're welcome!

[@freeman5453]

very helpful

[@ExcelBasement]

Glad it helped!

[@amazon5665]

when i add file to a folder using power query, as soon as I import the sorting goes out of order, how to overcome this issue.

[@utsav_blog]

which excel version is this?

[@charie0971]

tried this method still not working