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 all: Good day! I am getting data from a database table. There are 3 date columns. They are in date with time and TMZ format. I changed the column type to “Date” to only show date. Now need to show the time also. When I go to Power Query & try to change to Date/time, it shows there in the query editor- but not on the ‘Data view’ or ‘Report’ [my ‘Table’ visual]- remains same as before with only Date! [yes, I did ‘Apply & Close’!].
I found only solution is to start from beginning in Power query: removing all steps. Then from original date format-> change to date/time. But there should be an efficient way than this?
Any help is much appreciated! 🙂
Solved! Go to Solution.
@sohananahid - So when you originally set the field to date/time and applied, did you go to the column in your Report or Data view in Desktop and in Column Tools switch it to be date/time instead of date?
@sohananahid - So when you originally set the field to date/time and applied, did you go to the column in your Report or Data view in Desktop and in Column Tools switch it to be date/time instead of date?
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |