Forum Discussion
Timestamp format
- 4 years ago
Hi, Anonymous
Please try to change type and select the locale of origin.
Best Regards,
Community Support Team _ Eason
Hi, Anonymous ,
That's strange, could you please share those lines so I can copy it to my power bi and try to recreate your exact issue with your data please?
| 4/25/2022 2:05:20 PM +00:00 |
Data type is: date/time/timezone
- vojtechsima4 years agoSuper User
Hi, Anonymous
I did test it on my own and I can't replicate your issue:
Make sure, you put "en" as culture argument when you're choosing the date/time/timezone data type. And then you create new column like this:
Here's my Query, you can copy it to your Blank Query in Power Query and see for yourself:let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtE3MtU3MjAyUjCyMjC1MjJQCPBV0DYwsDIwUIqNBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type datetimezone}},"en"), #"Inserted Time" = Table.AddColumn(#"Changed Type", "Time", each DateTime.Time([Date]), type time) in #"Inserted Time"- Anonymous4 years agoNot applicable
Thanks, the table is from ADX (kusto) and the method is directQuery so I used add column and extracted time from it, but the output was odd. I will try with your Query and check
- v-easonf-msft4 years agoCommunity Support
Hi, Anonymous
Please try to change type and select the locale of origin.
Best Regards,
Community Support Team _ Eason