Curtis Ramirez on 03 Nov 2017 21:14:52
As of now, the reports that I create on desktop utilize a lot of time intelligence functions and relative date filters. This is completely fine so long as I view the report on the desktop. Once I publish the report up to the service and then utilize those visuals in dashboards I run into this issue. All of my time intelligence functions (TODAY & NOW) and relative date filters convert to UTC.
This issue causes my data to roll over to the next day 5 hours early which affects all of my subscriptions.
It would be absolutely fantastic if Power BI service could recognize local time zone or even if we could manually set our time zone so that these measure work correctly.
- Comments (69)
RE: Handle local time zone in Power BI service
Is there a fix yet? [2]
RE: Handle local time zone in Power BI service
Is there a fix yet?
RE: Handle local time zone in Power BI service
Fix this please!
RE: Handle local time zone in Power BI service
I work in New Zealand (UTC+12 hours), so our reports are correct in the morning, got to lunch and they are now different.
Tried work around and no result. Can this not be an option on the slicer "Use Local Time for relative dates"?
RE: Handle local time zone in Power BI service
updates on this??
RE: Handle local time zone in Power BI service
I don't believe you can't make a simple thing like local time working.... OH! Wait, I forget you are microsoft software, that's why every single thing are broken !
RE: Handle local time zone in Power BI service
'It's not even just measures. It's anything to do with date's. Whether they're used in a measure or just a table that displays the date.
The issue is that reports existing in the service are hosted by servers in utc time. So when the service determines what the "system" time is, it will always be in UTC.
The only workaround I've found is to subtract/add a static number of hours you need to make the datetime display in your local time. I'm in United States Central Time so I use:
-TIME(6,0,0) in CDT and -TIME(5,0,0) in CST.
This is suboptimal for users in a regions that recognize daylight savings time; since you'll have to update your formula twice a year to subtract or add an extra hour.
Please, please make this a priority, ms!!
RE: Handle local time zone in Power BI service
Any update on this?
RE: Handle local time zone in Power BI service
Any update on this issue so far?
RE: Handle local time zone in Power BI service
This is important. When connected to an SSAS live connection, a DAX formula can't be used as a work around.