Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I saw support was added this month for UTCNOW and UTCToday...but that just returns the UTC value right?
It does not take UTC time and convert it to the local time of whoever is viewing the report?
Is there a builtin way to do this yet?
Thanks!
HI @OneWithQuestion,
As you said, UTCNOW and UTCTODAY will return UTC datetime. If you want to get local datetime, why don't you use NOW and TODAY function to get local datetime?
Notice: NOW, TODAY functions still not works on power bi service.
Time in PBI Service is inconsistent with the local time (non-UTC time) displayed in PBI Desktop
Regards,
Xiaoxin Sheng
@v-shex-msft/ Xiaoxin Sheng
Is it planned to provide an implementation by Microsoft for
Power BI service to evaluate the browser time zone settings?
Best would be if the new implementation would do something like:
1. Get the current time zone setting of the connected browser
2. Allow (via dedicated datetime methods) filtering and display to use that request specific user time zone
= Users from Australia see the same reports as those from Europa as those from the USA.
But: Those from Australia with the appropriate Australian time zone, those from Europe ...
Example:
The very same record would show 01:40 May 1, 2018 in Australia
But: 17:40 April 30, 2108 in Switzerland
And: 11:40 April 30, 2018 in New York
Regards, David
That is why (as you mentioned) the NOW does not work in the service.
What I need is to display data to the end users that was stored as UTC but needs to convert to their local timezone.
*Timesheet data or error log events, etc... stored UTC but need to go to local timezone of user viewing service.
How many users are you dealing with? If it's not huge, you could consider building a simple table of users and their default time zones, then using the username function, pull through who's using the report and have it look up and adjust your time fields accordingly?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |