time zone region updating to +0:00 when refreshed in the online environment

[leigh_f]

Hi There, 

I'm finding that my data is being converted to +0:00 when publishing it online. 

When working in the desktop app, 

The data is originating from an Australian Dynamics 365 system, through the dynamics connector. 

It was coming incorrectly originally which I resolved through the transformation below

= Table.TransformColumns(#"ColumnX",{{"Date", DateTimeZone.ToLocal, type datetimezone}})

In addition I changed the desktop locale region to be australian to get the dates to update correctly. 

This worked brining the times and dates to be +8:00

When publishing it kept the correct times / dates originally, then on the first refresh, it restored back to the incorrect +0:00

I can't see any options in the online environment to change the region and it seems to pick up only +0:00

The main issue with this, is that it making a number of dates incorrect. 

Is there anyway to fix this in the online environment?

It seems like the region is always set to +0:00 which affects the local time. 

[lbendlin · Accepted solution]

https://radacad.com/solving-dax-time-zone-issue-in-power-bi

[lbendlin · Accepted solution]

https://radacad.com/solving-dax-time-zone-issue-in-power-bi

[leigh_f · Accepted solution]

Cheers Ibendlin that link ended up being a partial solutuon to the issue but didn't show how to update the orignal column. 

ultimately I could not find a way to update the timezone for this query

= Table.TransformColumns(#"ColumnX",{{"Date", DateTimeZone.ToLocal, type datetimezone}})

What I could do as a work around instead was create a new column
= Table.AddColumn(#"Rename Column", "Date", each DateTimeZone.SwitchZone([#"Date"],10))

After this I needed to
Change the type to the date/time/timezone
Delete the original column 
Rename the new column to match the existing column's name 
This then rolled down to the following calculations.