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 .
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:
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 timezone issue
Relative Time Slicer UTC
Convert UTC to local time zone in DAX
Hope this helps.
Best Regards,Community Support Team _ Zeon ZhengIf 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
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.