Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm importing data from an csv file, there is a column showing date, time and time zone information.
This column is loaded as text, how can I convert it into date time format?
Thanks!
Solved! Go to Solution.
Hi @Jeanxyz ,
you can change the data type using the data type icon in the column header.
I don't know how important the time zone is, you should remove it beforehand. Extract the first 19 characters.
Hi @Jeanxyz ,
you can change the data type using the data type icon in the column header.
I don't know how important the time zone is, you should remove it beforehand. Extract the first 19 characters.
Thanks, it works! I didn't realize that time zone information is causing the problem.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |