Sam Vanhoutte on 30 Jun 2015 19:51:50
We are keeping all of our time values in our data sources as UTC (as we consider this a best practice for our international customers).
However, when showing those dates in PowerBI reports, we’d love to get the option to visualize that date as a local timestamp, instead of the UTC timestamp.
I know this is not something that everyone needs as a default, but having the option to mark a field with datatype ‘utctimestamp’, for example would be a good solution.
- Comments (33)
RE: Support for visualization of UTC timestamps
This is now implemented.
RE: Support for visualization of UTC timestamps
This is mandatory. See also http://community.powerbi.com/t5/Service/Timestamp-only-have-date-when-directly-connect-to-SQL-database/td-p/3678
RE: Support for visualization of UTC timestamps
Power BI discards the time field and displaying only date in the visualization. Also tried to split the time field to a separate column, Still its converting it into a date field.