Skip to main content

Power BI

Needs Votes

Support for visualization of UTC timestamps

Vote (490) Share
Sam Vanhoutte's profile image

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)
Sam Vanhoutte's profile image Profile Picture

77afc3cd 291b-42da-9826-cd98d029a6cc on 05 Jul 2020 22:08:37

RE: Support for visualization of UTC timestamps

This is now implemented.

Sam Vanhoutte's profile image Profile Picture

77afc3cd 291b-42da-9826-cd98d029a6cc on 05 Jul 2020 22:08:06

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

Sam Vanhoutte's profile image Profile Picture

ce6fca46 ebdd-492f-a637-33c9eb46b14b on 05 Jul 2020 22:00:02

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.