Forum Discussion
Time issue UTC/BTS in Power BI Service
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.
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.
2 Replies
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.
