Support for visualization of UTC timestamps
We are keeping all of our time values in our data sources as UTC (as we consider this a best practice for our international customers…).
However, when showing those dates in PowerBI reports, we’d love to get the option to visualize that date as a local timestamp, instead of the UTC timestamp.
I know this is not something that everyone needs as a default, but having the option to mark a field with datatype ‘utctimestamp’, for example would be a good solution.
Edgar Walther commented
I just ran into this issue for the first time, but I'm surprised that this is not standard functionality. There should be a way to show a utc date in the users' local time zone.
Tripp Donnelly commented
timezone functionality in power query and DAX is limited and does not support users from multiple time zones. The proposed solution, indicating the data's timezone then converting it to the users timezone is the right solution!
I am really surprised about how MS had successfully parked aside some of the basic minimum requirements while advertising about other advanced feature things. This issue has been reported since a few years now and no action whatsoever have been taken to address this
Alex Gonzalez commented
Jason Campbell commented
This is greatly needed. As others have said, it's a basic feature that should not have been ignored. Especially since it's marketed/implemented over multiple time zones.
Swapnil Desarda commented
Nicolas Plourde commented
A basic feature that should of been there from the start.
Rick Gilbert commented
This is an unacceptable state, and I cannot understand why it has not been fixed. A lot of junk bells and whistles have been added, but this is a fundamental need for my customers.
Peter B commented
This is a source for great confusion! I can't understand why there's still no solution?!
Wow, that rhymes ;)
Would really like to see this change. Our business is global and the time stamping for last refresh is confusing our users and is giving them an irritating user experience in an otherwise excellent product.
I had to add another column on Bi Desktop to convert the time to local time, and when I export to share the dashboard online to app.powerbi.com guess what happen?
The converted column is converted again to UTC!!!
THANKS A LOT MICROSOFT FOR DOING NOTHING!!
Philippe Desjardins commented
i'm losing my hair over this. It should be standard. I have to know how much tickets from my system is new from today. I can't....
If i didn't have a daylight saving time in my timezone, i would only add an offset, but i have two differents offset depending on the time of the year... WHy the heck is the online published time always UTC? why can't ipick the timezone i want ???????
I use a 100% microsoft workflow, from my system, to logic apps, to cosmos db, to powerBI
Raymond Boone commented
I can't believe how truly difficult this has been to take time from an Azure DB and convert to local time. This really should be a simple thing--like set report time to use local time zone switch or something.
It is insane that this has not been adequately addressed by now.
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.
This is extremely frustrating. As stated by Andy below, the functionality should exist to allows web server users to specify their timezone.
Andy Fordyce commented
I'm sure I'm not the only person who is using Power BI plus Chromecasts to display dashboards. The lack of time zone options means that automating refresh of them requires a janky workaround, and nobody in my organisation but me can really use our dashboards as a result.
While displaying data is fine, our users need to interact with our data in Power BI to answer their own questions. This issue presents a practically insurmountable barrier to our end users, and I consider Power BI unfit for purpose while this issue remains.
Please either implement datetimetimezone in DAX as a data type, or preferably allow users of the web service to specify a time zone in which to operate.
We are in UTC +10:30 time zone. So metrics where I have used Today() function suddenly change drastically after 10:30 am. Date/Time functions should follow local time zone.
I am in US and after 6 PM today sales shows empty because Power BI service located in some server where it goes to next day. Need the solution ASAP