Forum Discussion

Epercini's avatar
Epercini
Regular Visitor
1 year ago

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 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 ?

Dataflow

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Epercini ,

     

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

     

    Best Regards,

    Wearsky

    • Epercini's avatar
      Epercini
      Regular Visitor
      1 year ago

      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 ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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