Forum Discussion

Numan_Dev's avatar
Numan_Dev
Frequent Visitor
1 year ago

Wrong date values after publishing report

Hi, I have a report with 2 very important date columns. Unfortunately, when I upload this report to the Power BI service online, these date columns contain incorrect values. While in the desktop app...
Need Help
pallavi_r's avatar
pallavi_r
Icon for Super User rankSuper User
1 year ago

Hi Numan_Dev ,

 

This might be happening due to difference in Power BI server timezone and your local time zone.

Add a dax or power query step to incorporate the timezone difference in your calculation.

https://learn.microsoft.com/en-us/powerquery-m/datetimezone-switchzone

There's a good article posted by Reza Rad, you can check that implement.

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

Let me know if you have any query. Happy to help.

 

 

If this post helps, please accept this as a solution. Appreciate your kudos.

 

Thanks,

Pallavi

Numan_Dev's avatar
Numan_Dev
Frequent Visitor
1 year ago

Hi pallavi_r,

thank you for your reply, I might try this out. But this solution sounds very strange to me, as I have set the datatype to "date" only. Shouldn't the dates be correct out of the box, instead of having the user to implement unnecessarily complicated logics to prevent this behavior?