Forum Discussion

EduardoAASanti's avatar
EduardoAASanti
New Member
8 years ago
Solved

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

2 Replies