Convert String to date and time

[mcdermjj]

Hi There 

I would like to convert the string formats below in my DATETIME column into a useable Date and Time Column such as 2023/06/16 22:45:00 , so Power Bi can recognise it as  a real Date and time  format for use. Thanks

2023061612245000

2023061612244900

2023061612244800

[devanshi]

Just select the that column & change datatype text to date/time. It automatically convert in date time formate

[mcdermjj]

Hi there, unfortunatley that gave me  error 😞  so trying adding a column and extracting the first 8 Characters. for date and then changing data type to date ( That seems to work ) and then Just trying the last 8 for time and its not working for data type change for time.. will keep trying 

[devanshi]

Try this one,
Go to transform tab, then 

Click one from this , select date/time datatype .