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
This would be especially useful to display on headings as well without requiring a table to contain this information.
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
Please, Please, Please, add this ASAP.
Its crazy that we cant track daily sales past 4pm, when the UTC clock rolls into tomorrow. 23 other time zones exist and cant get accurate data in real time until you fix this.
I have tried using a on premise gateway, and scoured the forums looking for a solution.
You MUST fhis issue ASAP
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
This is a major limitation to the otherwise great time intelligence functions.
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
This issue affects our international business analytics. Please add this ASAP
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
Couldn't agree more. It's really frustrating that this feature isn't available. Please add this in.
RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions
Am having a similar problem in New Zealand (where we are first to see the new day). Am using relative date filter set to last calendar month. However it doesn't recognise that the month has change until midday on the first day of the month.