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 (46)
RE: Support for visualization of UTC timestamps
There is a workaround, but if you're dealing with many clients across timezones, it can get really messy really fast. http://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/
RE: Support for visualization of UTC timestamps
My suggestion would be to add local timezone as a setting in the PowerBI service general settings. That way, you can publish a pbix using .LocalNow function and the service would look to your PBI setting to do the appropriate conversion.
RE: Support for visualization of UTC timestamps
anybody knows some workaround?
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.