Forum Discussion
DataFormat.Error: We couldn't parse the input provided as a DateTime value
- 3 years ago
That is a DateTimeZone format. You will need to use DateTimeZone for the field type, then click on Change Type again and change to DateTime and make sure it adds a step, not replaces.
You will have two change type steps.
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMtQ1NNA1MgwxNLQyNbcyMNM2NLYyMFCKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type datetimezone}}), #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type",{{"Column1", type datetime}}) in #"Changed Type1"How to use M code provided in a blank query:
1) In Power Query, select New Source, then Blank Query
2) On the Home ribbon, select "Advanced Editor" button
3) Remove everything you see, then paste the M code I've given you in that box.
4) Press Done
5) See this article if you need help using this M code in your model.
I see there are other responses provided that have worked for you; but just in case it doesn't work for someone else, like me haha, here's another method you can try:
When you import your data (mine was imported from excel), you'll initially have to change your date columns from text to whole number. Then change the data type from whole number to date or datetime. This is the only thing that worked for me. Hope this helps!
- ExceltilliDie1 year agoNew Member
This worked for me -Thank u so much 🙂
Found your response after searching stuff for an hour!!