Allow formatting datetimezone fields to user local timezone

[basson_christia]

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.

[kendalllister]

It's not just a new feature that's needed - the Power BI desktop client just doesn't seem able to handle dates properly when used in some time zones, e.g. Australian Eastern Standard Time. Essentially the same problem Mich I reported for October 2017 happened again in April 2018, as per: https://community.powerbi.com/t5/Desktop/April-fools/m-p/391979 https://community.powerbi.com/t5/Issues/Issue-with-April-Ist-2018/idi-p/404711 https://community.powerbi.com/t5/Desktop/Issue-with-filter-after-uploading-April-2018-data/m-p/399454 and so on.

[jorgerivera1]

very, very needed!

[JeffM]

Native timezone handling of Daylight Savings Time during timezone conversion would be beneficial to me as well. I am charting purchases by hour, and the hour of the day obviously is not going to convert properly year-round with a simple offset against a date column that is stored in UTC. My target db is MySQL and I realize that MySQL does support timezone conversions IF the timezone table data has been loaded by the DBA. It has not in my case, and the quick workaround would have been for me to take care of this in PowerQuery.

[kevhav1]

Yep, I wish I could do at least one of the following... 1. Take my date/time values stored in the data model (e.g. in UTC), and create a DAX measures to return the date/time in the Power BI Service user's local time zone. (And, another DAX measure to say what the user's local time zone is.) 2. Store date/time/timezone values in the data model ... and, have a way for the Power BI Service to convert those values, in reports, to the user's local time zone.

[anonymous6]

Aggreed on this one. All my data is in UTC but when reporting, everything needs to be at local time

[all2neat]

This would make my life soooo much easier.

[firmin_hendrick]

Hi, Please try DateTimeZone.RemoveZone(DateTimeZone.ToLocal(DateTime.AddZone([#"Date_UTC"],0))) Hope it helps !

[susana_milian]

I need to show in a Powe BI report the last refresh date/time of the data. I keep the date of recharged in a table with a single row and a single column. But this is the UTC time. Now I return the one from Spain, but I would like to be able to return the local time of every user. I think that Power BI should have a function to get the time zone of the current user who is using the Power BI service.

[dszepesi1]

I am playing around with importing data from JSON files and am tangling with trying to convert JSON Date/Time to something that I can work with. This could be a lot easier couldn't time? TZ seems to be something that is always such a pain - can you help me not shoot myself in the foot.....repeatedly?

[toby_fulton]

Please fix this! Just spent quite a few hours trying to figure out why 30/09/2018 is showing as 29/09/2018 due to daylight savings change in New Zealand.