Forum Discussion

po's avatar
po
Post Prodigy
5 years ago
Solved

display date/times in local timezone rather than UTC

Hi,   From my understanding service display s dates/times in UTC format.   If in U.K. what is the best way to ensure dates/times always displayed in local time zone (i.e. as clocks move forward 1...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi po ,

     

    Powerbi Service now only supports utc time, if you want to display the local time, you can create a custom column in Query Editor use DateTime.LocalNow() and #duration() function.

    https://docs.microsoft.com/en-us/powerquery-m/sharpduration 

    For example:

    DateTime.LocalNow()+#duration(0,2,0,0)

     

    Best Regards,

    Jay

aj1973's avatar
aj1973
Community Champion
5 years ago

Welcome,

Did you do it? if so please mark this thread as accepted for the rest of the community

 

po's avatar
po
Post Prodigy
5 years ago

Hi,

 

Had thought was working but was just using the cached version in service of the desktop version.

 

After refresh in service not working showing utc.

 

o.k. in desktop but not in service.

 

 

if use now() when time in u.k. is 9.30 a.m. service shows as 8:30 a.m. i..e utc time.

 

How can we ensure dynamcially that now(*) and similar finctions will alwys evaluate tp correct uk time all days of the year dynamically?

 

Thanks