Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
PWRBI
Frequent Visitor

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 2
v-chuncz-msft
Community Support
Community Support

@PWRBI 

 

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

 

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PWRBI
Frequent Visitor

can nobody help me? 😞

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.