Dataflow Time zone

[Epercini]

In the power query of the dataflow, every time i get a data information on our database the dataflow automatically would reduce a date/time in 3 hours, wich is correct because of the timezone difference, but now i don't now why, the dataflow is reducing only in 2 hours, nothing in the database has changed only the dataflow seems to has changed, how can i reconfigure to 3 hours again ?

[v-xiaocliu-msft]

Hi @Epercini ,

Yeah, it is a bit weird. So the above is just an alternative.

Could this be due to daylight saving time?

Best Regards,

Wearsky

[v-xiaocliu-msft]

Hi @Epercini ,

Please try to use this formula in power query
DateTime.AddZone([YourDateTimeColumn], *)

Best Regards,

Wearsky

[Epercini]

Hi, isn't strange that sudden the UTC changed -3 to -2 automatically?, because we have a lot of tables that used this rule, i would have to do in every column from every table in dataflow, isn't there a way to change to -3 to all of them ?