Date value changes while exporting to excel in power bi services

[Anonymous]

Hi All,

I need some help in my issue. I have date format of 1/1/1900 or 1/1/00 - while exporting this date format column in desktop level the output is coming fine. But after publishing the report to services, when i try to export my report to excel from power bi services, the date is getting changed from 1/1/00 to 1/2/00. i am unable to find the root cause for it. Please help me out with this issue.

1st image - Is the date format in power bi services
2nd image - Is the date format in excel after exporting it from power bi services

OUTPUT IN SERVICESOUTPUT IN EXCEL AFTER EXPORT

[djurecicK2]

Hi @Anonymous ,

 It seems like this could be related to Time Zones. The Power BI Service uses UTC.

Here is some additional information:

https://whitepages.bifocal.show/2020/10/dynamic-time-zone-conversion-using-power-bi/