Forum Discussion
How to change the dates UTC to Local
Hi, Mallika_n
Not sure which method is right for your case so I've posted as many references as possible below. I hope some of these methods are useful to you.
Here are some references that may be helpful:
community:
display date/times in local timezone rather than UTC
Desktop refreshes correctly show the converted local time dates but the Service reverts back to UTC?
UTC to Local as measure
Convert UTC to local time zone in DAX
blogs:
https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/
https://cloudbi.com.au/converting-utc-to-local-datetime-in-power-bi/
https://nolock.medium.com/how-to-convert-utc-to-your-local-time-zone-in-power-query-c10538fa849a
https://www.thepoweruser.com/2019/10/21/handling-different-time-zones-in-power-bi-power-query/
https://whitepages.unlimitedviz.com/2020/10/dynamic-time-zone-conversion-using-power-bi/
https://intellitect.com/convert-utc-local-time-daylight-savings-support-power-bi/
https://forum.enterprisedna.co/t/converting-utc-to-local-time-zone-in-power-bi/11346
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Nothing worked for me ☹️, I am getting data now but in desktop it is showing todays date and in service it is showing blank instead of date untill 12pm nzst