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
Any update on this?
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
My recollection (and the way that this idea has been described) is that it used to only be an issue in the Power BI Service. However, I now have the same problem with the relative date filters on PowerBI Desktop which also use UTC. Realy hoping for some development focus on this soon.
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
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.
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
Wow....shocked that this is an issue. PowerBI really needs to get this sorted.
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
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.
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
yes ! We need this badly.
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
Please release this fix
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
Yes, this is very important for reports that should work globally.
We expected that "cloud-based ... business analytics tools ... suite for (world-wide) organization to consume on the web" - would support the use of local time zones.
(With only UTC it only fits Iceland and some countries in west Africa... All others are puzzled by the indicated date & time.)
Best would be if your new implementation would do:
1. Get the current time zone setting from the connected browser
(see: https://www.w3schools.com/jsref/jsref_gettimezoneoffset.asp )
2. Allow (via dedicated datetime methods) filtering and display to use that request specific user time zone
Example:
The very same record would show 01:40 May 1, 2018 in Australia
But: 17:40 April 30, 2108 in Switzerland
And: 11:40 April 30, 2018 in New York
Best regards, David
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
This is CRITICAL!
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
This would be super useful!