Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |