Christiaan B. on 29 Aug 2017 05:15:12
Typically date & time information is available in UTC (if not then put it to UTC at source), you just want it rendered in the users' locale/time zone at reporting time.
Adding an option to format datetimezone fields in the users' locale/time zone (based on the user account settings) would probably solve 90+% of requirements for rendering time zone information.
Currently MS does not provide for showing offset information (or local time zone) as you only have date/time format options, but in the query editor you can set type to datetimezone which show offset info so it's clearly available - just the rendering that lacks.
Not having this functionality is forcing people to resort to hacks like using DateTimeZone.AddZone () with hardcoded time offsets - not scalable where DST is involved. Current workarounds obviously only work as long as the viewer is in the designated time zone and does not scale across a global audience.
- Comments (36)
RE: Allow formatting datetimezone fields to user local timezone
Yes, this would be great. I have data coming in as UTC and I want to easily convert it to my local time zone.
RE: Allow formatting datetimezone fields to user local timezone
Agree this is needed. Spent hours trying to decipher why date/time of 1st October 2017 12:00:00 converts itself to 30th September 2017 11:00:00 in reports and hence reports data under the wrong month. (Sydney - AEST - changes to daylight saving at 2am on the 1st October 2017)
RE: Allow formatting datetimezone fields to user local timezone
Certainly would save a lot of time. Previously I had to actually lookup the DST times for the target timezone for the next 5 years, then come up with a hard coded m query to convert. After 5 years, it won't be displaying data properly and i'm sure i'll be somewhere else.
RE: Allow formatting datetimezone fields to user local timezone
We need a way to display data in our local timezone accounting for daylight savings time. The data source stores the dates in UTC but we need reports to show local time. A native and easy way to do this in PowerBI would be a huge help. There are many blog posts and help articles floating around with solutions people have attempted but it's a simple issue that so many users would benefit from having solved centrally by PowerBI itself. Please consider!
RE: Allow formatting datetimezone fields to user local timezone
Since we will be deploying reports and dashboards for a global audience, this functionality is absolutely critical--and basic. We simply cannot tell our users to look at time series data and to "do the math" in their heads for their timezone.
RE: Allow formatting datetimezone fields to user local timezone
When we use Event Hub, IoT Hub or the system datetime in Stream Analytics the timezone considered is the UTC.
It would be interesting to be able to see data represented in the user timezone in PowerBI.