Forum Discussion

wpf_'s avatar
wpf_
Icon for Post Prodigy rankPost Prodigy
4 years ago

date/time field is offsetting incorrectly

I have a date/time field that i pull in from Dynamics.  It is offsetting it to UTC.  Now I was under the assumption that BI automatically offsets the times based on daylight savings time.  It does do that, but it seems that the DST date/time is off. 

 

For example i am in EST and DST is 3/13/22 at 2AM.  In BI, it does not change the offset from -5 to -4 until 3/14/22 at 12AM.  

 

How can I fix this?

Need Help
Show and Tell

1 Reply

  • littlemojopuppy's avatar
    littlemojopuppy
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi wpf_ Power BI does not offset from UTC to local time.  Actually, the Power BI service runs on UTC time.

     

    You can correct for this in Power Query by using the function DateTimeZone.SwitchZone.  You'll probably have an issue with daylight savings time (if you are in the US or Canada) because you have to specify a fixed number of hours before or after UTC your target time zone is.

     

    Hope this helps!