Forum Discussion
We couldn't parse the input provided as a DateTime value..
- 6 years ago
Nimai123 , refer is these can help
Check the exact error on power query
handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs - 6 years ago
You should be able to convert text formatted date's to dateTime without any issue so there is something trong with the text. It might be that it's the wrong delimiters or that there are other blankspaces present in the date. If you provide an image of the dates I might be able to see if there are any issues directly.
Otherwise what you can do if you really can't get it to work is splitting the text column up in year, month and date and use this custom column to create a date: (Make sure that all three columns are formatted to whole number)#date([Year],[Month],[Date]) as date
Br,
J
Then i believe thats the issue. A text value date in the format xx.xx.xxxx is read as mm.dd.yyyy for me, meaning that every date with a day above 12 will return an error.
I'm going to be perfectly honest with you, I don't know if it's possible to change this by toggling the locale. Due to the SAP datasource I'm assuming the process of adding another column to the source is a little more than a 30min tweak?
/ J