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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
EduardoAASanti
New Member

Daylight Saving Time with weird behavior

Dear all,

 

I am having an weird behavior with Daylight Saving Time (Brazilian Time). I have a "date" column in my DB located in Azure. When I load the data in Dashbord inside my PowerBI Desktop, the behavior is correct:

 

13/10/2017 00:00:00

14/10/2017 00:00:00

15/10/2017 01:00:00 (+1 because of Daylight Saving Time in Brazil)

16/10/2017 00:00:00

 

The problem is when I open the Dashboard in Web (app.powerbi.com). The result for the same is:

 

13/10/2017 12:00:00 AM
14/10/2017 12:00:00 AM
14/10/2017 11:00:00 PM (-1 because of Daylight Saving time in Brazil)
16/10/2017 12:00:00 AM

 

The consequence is, when I group by date, it repeats "14/10/2017" in the chart. Any sugestion in how to hangle it?

 

Thank you in advance,

Eduardo Santi

1 ACCEPTED SOLUTION
v-sihou-msft
Employee
Employee

@EduardoAASanti

 

You can use DateTime.AddZone() function and DateTimeZone functions in Power Query to solve daylight saving and time zones issue. For more details, please refer to articles below:

 

Daylight Saving Time And Time Zones In M

Solving DAX Time Zone Issue in Power BI

 

Regards,

View solution in original post

2 REPLIES 2
v-sihou-msft
Employee
Employee

@EduardoAASanti

 

You can use DateTime.AddZone() function and DateTimeZone functions in Power Query to solve daylight saving and time zones issue. For more details, please refer to articles below:

 

Daylight Saving Time And Time Zones In M

Solving DAX Time Zone Issue in Power BI

 

Regards,

I have put in a feature request for PowerBI to natively support timezone and DST conversion. Please upvote if you'd like to see this happen: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33732571-time-zone-conversion-acc...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors