Forum Discussion
How to change the dates UTC to Local
Hi,
I have created report in Power Desktop and Published to the service it is working fine in Desktop,
but i have an issue with dates after publishing to service. Every visual is working fine except the rolling average visual, where as it working fine after 12Pm NZST.
please help me to get the correct date .
4 Replies
- lbendlin
Super User
You may want to consider this article Solving DAX Time Zone Issue in Power BI - RADACAD
- Mallika_nFrequent Visitor
Thanks for the Response I tried 1 and 2 methods but Didn't work for me.
- v-angzheng-msft
Community Support
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.- Mallika_nFrequent Visitor
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