cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OneWithQuestion
Post Prodigy
Post Prodigy

Convert UTC to local client timezone?

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!

4 REPLIES 4
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

@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?

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors