Forum Discussion
Solved
Error converting data type to date but not if converting data type to datetime first
I have data in a column detected as text like this 18/05/2021 15:15:33 If I try to transform it to date, PowerBI throws an error 'couldn't parse the input as a Date value' If I try to transf...
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMrTQNzDVNzIwMlQwNLUCImNjpdhYAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [data = _t]), to_date = Table.TransformColumns(Source, {"data", each Date.From(DateTime.From(_, "de-DE"))}) in to_date
= Date.From(DateTime.From("05/18/2021 15:15:33"))