Forum Discussion
gghlyon
8 years agoFrequent Visitor
Daylight saving malfunction with December release
Hi all, Can't find this problem on the forum, please let me know if solved elsewhere. We maintain a date table, pull through direct query to PowerBI. As of the Dec release (automatic upd...
v-sihou-msft
8 years agoMicrosoft Employee
I can't reproduce your issue. But you may use Power Query to transform Daylight Saving Time. Please refer to articles below:
Solving DAX Time Zone Issue in Power BI
Daylight Saving Time And Time Zones In M
Regards,
gghlyon
8 years agoFrequent Visitor
Hi,
Thanks, it's not a normal timezone offset though.
Have tried to share a picture that simulates what i'm seeing below. See how just the one wrong day affects the month and quarter. Again, on the SQL data this is not happening, just when loading into powerbi desktop Dec version.
Guy
- cs_rob8 years agoFrequent Visitor
Hi gghylon,
Did you manage to find a solution to this? I've also encountered the same frustrating issue.