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
Note that when there are users from different timezones and also different local daylight saving practices, which impact the datetime.
RE: Handle local time zone in Power BI service
Yes, fix this already for crying out loud. (A scary thought just occurred to me: Perhaps no one at Microsoft is reading this thread... would explain why it's been taking forever. 4 years and counting... I guess there is no shame in taking one's sweet goddamn time, now is there!?)
RE: Handle local time zone in Power BI service
i need this fix asap please
RE: Handle local time zone in Power BI service
Please fix this. As other commenters have said, at 5pm Arizona time, my reports go blank because I'm filtering on the last day for my report.
RE: Handle local time zone in Power BI service
We've created tables and functions to address this even to address data being pulled in from the Dataverse. There has to be a way to either read a cookie, ask the user as a preference or some other method to preserve this within the service instead of always forcing a workaround or forcing UTC time.
RE: Handle local time zone in Power BI service
Please fix this!
RE: Handle local time zone in Power BI service
Amazing this has not been corrected over the years.
The fact you can have different results in a report opening it in the PowerBI Desktop but then have it immediately be something different just by publishing it to the service is ridiculous really.
RE: Handle local time zone in Power BI service
This is painful issue.
RE: Handle local time zone in Power BI service
Please fix this. Important to IoT streaming workflow.
RE: Handle local time zone in Power BI service
Similar idea here: https://ideas.powerbi.com/ideas/idea/?ideaid=f653dcc6-ca73-41e3-a210-4197114ac54a