Power BI
Needs VotesPower BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
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 (46)
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
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: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
updates on this??
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
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: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
'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: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
Any update on this?
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
Any update on this issue so far?
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
This is important. When connected to an SSAS live connection, a DAX formula can't be used as a work around.
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
Time is fundamental.
The ability to specify time zone settings by report is critical for everyone in the world except London.
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
Yes please can we get this fixed. I have many reports that go blank at 4pm pacific time!
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
This is also a real issue for our company and can only be resolved by Microsoft. The only solutions/workarounds that are possible will either avoid using relative dates all together or a formula that will only fix the issue for a particular relative time frame.
The main problem is that an individual only know to do this once they have been burned. There is almost no way to know intuitively beforehand. The current implementation is deceptive as the intended behavior changes as you publish it to the service. There are many ways that this can be resolved or made more explicit. Microsoft needs to implement one of them ASAP.
Be sure to raise an issue through your support contract. This should be treated as a bug and not a feature request.