Forum Discussion
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 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!
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
5 Replies
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
Hi beakon ,
You can refer to the online document about DateTime.AddZone function to achieve your requirement.
Regards,
Frank
Hi beakon ,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
FrankIt 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?
