Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.