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.
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
Alex P commented
This needs to get fixed ASAP. It makes relative date filters useless as well since they're off from the database's time. I shouldn't have to implement a complicated mess of DAX or M to have Power BI know what today() or now() means.
Scott A commented
Handle. Timezones. Better.
We also store all date/time values in UTC for consistency as our users are global. We currently use Tableau for dashboards/reports which too cannot handle the conversion to the timezone of the user viewing the data.
Having this functionality in PowerBI would be a major reason to switch.
Looking at other competitors it seems like a missing feature in all of them, but would be a major differentiator for customers with global platforms for whoever delivers the feature first.
I too would like to see this problem solved. When I advocate Power BI for clients, I do not want to have to tell them that I cannot display a refresh date other than UTC. I'm fine with it but, a client sees this flaw as a reflection on the entire product. This is not good for those of us who push this product. This fact, in and of itself, should make this a priority item.
I also don't understand why this can't just translate to local viewer timezone. The PowerBI desktop even has a timezone data type... you'd just you could just specify the offset for the data (so flag it with its UTC value) and then let the viewer adjust.
Alex Kyllo commented
Why does Power BI DAX not have a UTCNOW() function? This is so desperately needed.
The objective here would be to have a single timezone (UTC) saved in your dataset, then present it on the dashboard as a local time based on the users PBI localtime setting - great idea!
Maja Sehovac commented
My suggestion would be to add local timezone as a setting in the PowerBI service general settings. That way, you can publish a pbix using .LocalNow function and the service would look to your PBI setting to do the appropriate conversion.