Forum Discussion
Incorrect Date in Web
hello community,
I am new here and also a new Power BI user, I am very impressed with the tool.
But I have a problem, a date field from the database is displayed correctly in the desktop app, but I always see date-1 on the web.
Example:
Correct date should be 01.05.2020 (DD.MM.YYYY)
on the web, however, is displayed 30.04.2020
This is a huge problem because the month in the filter is then no longer May, but April.
The date comes from the database as a time stamp
I format the date like this:
DateTime.Date([Date_created])
Can you tell me what I have to do differently?
Thank you very much
2 Replies
- v-chuncz-msftCommunity Support
This might be caused by UTC time zone. You may refer to the following post.
http://community.powerbi.com/t5/Desktop/Dashboard-date-not-reverting-from-IST-to-PST/m-p/341337
- PWRBIFrequent Visitor
can nobody help me? 😞