Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Allow formatting datetimezone fields to user local timezone

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.
Status: Needs Votes
Comments
vithalmaddala
New Member
Its ridiculous that this isn't available in Power BI.
cplath
New Member
Here's a hacky workaround to handle offset with DST in the PBI service: https://community.powerbi.com/t5/Service/Handling-local-time-zone-with-Daylight-Savings-in-Power-BI/m-p/991812#M91044
kris_herbison2
New Member
Come on Microsoft, it is ridiculous that this is not available! Why can't the online server use the local time of the person running the report! Especially if the report is to be used in multiple timezone! Please get this fixed ASAP.
justin_jackson
New Member
Please implement!
Shaun_Wilkinson
New Member
Ridiculous this is still an issue - having to manually calculate offsets and then continually update those offsets to cater for daylight saving time or different regions.
raj_rao1
New Member
This functionality is sorely needed, especially when your PBI reports are used globally. Otherwise, what is the point of storing data with DatTime+Zone?
fbcideas_migusr
New Member
Status changed to: Needs Votes
 
ChristiaanB
Frequent Visitor
Noticed this today - https://learn.microsoft.com/en-nz/power-bi/connect-data/incremental-refresh-overview#current-date-an.... Supposedly 'sets' the time zone for service scheduled refresh... but still does NOT address global audience showing in their own local time zone. This needs to happen client side, not server side.