Forum Discussion
Epercini
1 year agoRegular Visitor
Dataflow Time zone
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 differe...
Anonymous
1 year agoNot applicable
Hi Epercini ,
Please try to use this formula in power query
DateTime.AddZone([YourDateTimeColumn], *)
Best Regards,
Wearsky
- Epercini1 year agoRegular Visitor
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 ?