Forum Discussion
EduardoAASanti
8 years agoNew 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
No RepliesBe the first to reply