Forum Discussion
Time Zone Issue
beakon wrote:It seems that my power BI client already thinks these dates are in Sydney time and therefore when I apply the DateTime.AddZone formula I cannot add more hours on top. I tried changing my computer's timezone and that seems to have fixed the issue. Is that what I should be doing?
Changing your computer's timezone should not be necessary. You could be hitting a similar issue to the one I hit here http://darren.gosbell.com/archive/2019/02/01/power-bi-ndash-fixing-dates-from-sharepoint-lists-converting-utc.aspx where Sharepoint was returning UTC times, but Power BI was not recognizing them as such. The fix was to change the data type to Date/Time/Timezone first then the DateTime.AddZone might start working
Community SupportHi beakon ,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
It seems that my power BI client already thinks these dates are in Sydney time and therefore when I apply the DateTime.AddZone formula I cannot add more hours on top. I tried changing my computer's timezone and that seems to have fixed the issue. Is that what I should be doing?
- d_gosbell
Super User
beakon wrote:It seems that my power BI client already thinks these dates are in Sydney time and therefore when I apply the DateTime.AddZone formula I cannot add more hours on top. I tried changing my computer's timezone and that seems to have fixed the issue. Is that what I should be doing?
Changing your computer's timezone should not be necessary. You could be hitting a similar issue to the one I hit here http://darren.gosbell.com/archive/2019/02/01/power-bi-ndash-fixing-dates-from-sharepoint-lists-converting-utc.aspx where Sharepoint was returning UTC times, but Power BI was not recognizing them as such. The fix was to change the data type to Date/Time/Timezone first then the DateTime.AddZone might start working