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
Please fix this! Seriously!
RE: Handle local time zone in Power BI service
At around 5PM Arizona time, my reports go blank for "Last 1 day" because of this.
RE: Handle local time zone in Power BI service
Please, I need this. I've been struggling with this issue so many times so far.
No one wants to calculate their timezone from UTC.
RE: Handle local time zone in Power BI service
Please fix, we have to maintain 2 to 4 versions of the same report and upload different version thoughout the day.
RE: Handle local time zone in Power BI service
Please Fix It!
RE: Handle local time zone in Power BI service
This doesn't solve the problem, but it is a work around for it in the interim: https://whitepages.unlimitedviz.com/2020/05/working-with-time-zones-in-the-power-bi-relative-time-slicer-and-filter/
RE: Handle local time zone in Power BI service
It's not a solution to the problem, and I totally agree that this is necessary, but in the meantime, this might help - https://whitepages.unlimitedviz.com/2020/05/working-with-time-zones-in-the-power-bi-relative-time-slicer-and-filter/
RE: Handle local time zone in Power BI service
Please fix this! Or somebody let me know a workaround. I'm using direct query and need real-time reporting. But there is no way I can do it if the system thinks it's tomorrow already at 6PM.
RE: Handle local time zone in Power BI service
Power BI team please fix this issue! It's very important for us.
RE: Handle local time zone in Power BI service
Still a problem. Please fix!!!