Aug 7 • Technical
Date Time values automatically Changing
I’m fetching data from Salesforce and storing it in a Lakehouse using a data pipeline. However, after the data is stored in the Lakehouse, I’ve noticed that the values in the DateTime-type columns are shifted—specifically, the timestamps are 4 hours ahead compared to the source data in Salesforce.
During my investigation, I’m wondering: does Microsoft Fabric automatically convert DateTime values to a specific time zone?
Based on my analysis, the 4-hour difference aligns with the time zone offset between UTC and EDT.
Although Salesforce operates in the EDT time zone, it stores and processes DateTime values internally in UTC.
If anyone has encountered a similar issue, I’d appreciate it if you could reach out or share your insights.
Thanks!!
4
9 comments
Date Time values automatically Changing
skool.com/microsoft-fabric
Helping passionate analysts, data engineers, data scientists (& more) to advance their careers on the Microsoft Fabric platform.
Leaderboard (30-day)
1
+32
2
+24
3
+19
4
+15
5
+13
Powered by