Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 .
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?
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
Thanks for the Response I tried 1 and 2 methods but Didn't work for me.
You may want to consider this article Solving DAX Time Zone Issue in Power BI - RADACAD
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.