Time Zone Issue

[beakon]

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 stored using UTC time zone, but in our web application most users use Sydney as a time zone (UTC+11). I know I can create a new date/time field and simply add 11 hours to the one that's coming directly from the database, but in that case I would have to replace the old one in all of the filters, charts, graphs and cards in the report (more than 50). Is there a way to modify the existing field so capture the date/time using UTC+11 time zone.

Thanks and have a great day!

[v-frfei-msft]

Hi @beakon ,

You can refer to the online document about  DateTime.AddZone function to achieve your requirement.

Regards,

Frank

[v-frfei-msft]

Hi @beakon ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank

[beakon]

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 · Accepted solution]

---

@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-conve...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]

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