We couldn't parse the input provided as a Date value.undefined

[Yollies]

My Excel file is quite simple

[v-shex-msft · Accepted solution]

HI @Yollies ,

According to the error message, it sounds like power query can't recognize these abbreviation value correctly. You can modify your date filed with long date instead of short date.
In addition, you can also use 'locale' on date type formatting, it can recognize different date format.(e.g UK date and US date)

Regards,

Xiaoxin Sheng