Forum Discussion
dkgcb
2 years agoFrequent Visitor
How to convert text into date, time and zone
Here is the data in the text column that I imported from a log file (Apache web logs). Locale is USA, English. I changed the project settings > options > reginal settings to use English (USA)
Jan 1 2023 11:37:23.86 CST
I'm getting error try to change the data type to Date/Time/Zone: DataFormat.Error: We couldn't parse the input provided as a DateTimeZone value
The only way I can think of is to split into separate columns, change the data, the combine them using '/' into a new column. Is there an easier way to have PowerBi recognize Jan 1 2023 11:37:23.86 CST as a date? It seems commonly used date format.