Forum Discussion

beakon's avatar
beakon
Frequent Visitor
7 years ago
Solved

Time Zone Issue

Hi Guys,   I have been having an issue with my Power BI report for a few days and I can't seem to find a proper solution for it.   Our data is coming from a mysql database where the dates are sto...
Need Help
  • d_gosbell's avatar
    d_gosbell
    7 years ago
    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

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
7 years ago

If you have access to edit the query used to populate the data model the following process should work:

 

1. Add a new column using DateTime.ToLocal( [<OldColumnName>] )

2. Delete the <OldColumnName> column

3. Rename the column created in step one to have the same name as your original column