Time issue UTC/BTS in Power BI Service

[JubJubBud]

Hi,

In Power BI Service I am seeing the wrong time. It is currently 17:43 not 16:43, any ideas how I can get the correct time.

What can I change my code to, to get local time which is BST time not UTC time. And ideally this code would work all year round even when clocks go back or forward. #ukproblems

Thanks in advance.

[v-jiewu-msft · Accepted solution]

Hi @JubJubBud ,

First of all, many thanks to  for your very quick and effective replies.

Based on my learning, power bi service only support UTC datetime. It not contain any features can auto transform datetime based on location.

Please try the following methods as workaround:

1.Open the Power query editor and select add custom column.

2.Enter the M code.

Time.From(DateTimeZone.FixedUtcNow() - #duration(0,1,0,0))

3.The Local Time is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @JubJubBud 

You could use this instead which should always start off with the time in UTC

Time.From(DateTimeZone.FixedUtcNow() - #duration(0,0,4,0)