Power BI

Needs Votes

Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

Vote (375)

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)

Comments (46)

f77455c1 89b7-4e9f-bf6b-f18b048f1fac on 06 Jul 2020 00:11:07

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

I see a lot of comments on if there is any update on this. Original poster here (from 2017!) and I have not seen or received ANY updates regarding this incredibly basic request.

528ddd3a 6236-4f88-9d44-cec5a386a379 on 06 Jul 2020 00:10:59

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

I should have the option to set my relative date filters and BI service clock to use local time. In order to track user logins by hour, I have to add 7 hours to my date in one column, subtract it again in another column. All just to trick the relative date filter without skewing my data. Fortunately I live in Arizona and don't have to remember to change that 2x a year. Why is this a thing? Where is the dev response this issue was posted in 2017 and still has recent bumps? This is really, really dumb. For real.

a8c2dd3a 4b23-4774-a93c-71f219e9b3f5 on 06 Jul 2020 00:10:20

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

Living in Australia is a headache.

5776957b 6a8a-4f8d-9565-d5cd10b5900c on 06 Jul 2020 00:09:11

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

Seriously Power Bi Team...get this fixed. So basic to not have and renders many reports useless or at least inaccurate. Why can't the local time of my laptop simply be recognized by Power Bi??

054a3c46 2d68-4a8b-b22e-ea2aa0a24dc5 on 06 Jul 2020 00:08:53

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

I mean an accurate is clock is fundamental to a significant amount of reporting. Can this please be fixed!?

69d38b9f fc7a-4ea3-94a5-14ade3bca427 on 06 Jul 2020 00:08:53

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

This is a major impact to live reporting for AEST. Is there a fix or work around for this?

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:07:17

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

Please fix for this! My work is time-specific!

7c035e80 ec91-4428-b165-2656bf199a7b on 06 Jul 2020 00:05:59

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

Is there a fix yet? [2]

7b1034e0 f41c-4214-a8f2-ad01caaeac1b on 06 Jul 2020 00:04:45

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

Is there a fix yet?

7db490fb ae29-42d1-9719-20820a99eaea on 06 Jul 2020 00:02:39

RE: Power BI Service recognize local time zone for TODAY () and NOW () time intelligence functions

Fix this please!