Last Refresh data issue

Hi, mdaamirkhan 

According to your description and sample DAX formula, it seems that you are facing the problem that the time zone can’t sync when the report is published to the web service.

This is because the power bi service only supports UTC DateTime currently. It doesn’t contain any features that can auto transform DateTime based on location.

Here’s a blog that describes several ways to deal with this kind of problem:

https://radacad.com/solving-dax-time-zone-issue-in-power-bi

You can also vote for and comment on the below idea submitted by other users, so the Power BI team can update that issue asap.

https://ideas.powerbi.com/ideas/idea/?ideaid=6636c895-418e-4477-9e68-f216c3162015

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi, mdaamirkhan 

The reason why this problem happens is explained in my first reply:

This is because the power bi service only supports UTC DateTime currently. It doesn’t contain any features that can auto transform DateTime based on location.

And it’s also an issue with great influence in the Power BI idea, you can also vote for and comment on the below idea submitted by other users, so the Power BI team can update that issue asap.

https://ideas.powerbi.com/ideas/idea/?ideaid=6636c895-418e-4477-9e68-f216c3162015

In my opinion, if you usually view your reports in the Power BI service most of the time, I suggest you to use the DAX formula I posted above to make the DateTime display correctly in the Power BI service. This is also the most effective way to use at present.

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.