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
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?
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