cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Daylight Saving Time with weird behavior

@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
Highlighted
Microsoft
Microsoft

Re: Daylight Saving Time with weird behavior

@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

Highlighted
New Member

Re: Daylight Saving Time with weird behavior

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.