Forum Discussion
Date and Time stamp from Sharepoint loading to wrong UTC
Hey all,
First time posting,
I have loaded a Sharepoint list into Power Query to find total working hours.
In Sharepoint, a column for a specific ID's request date is:
7/30/2019 1:52 PM
When loaded into power bi, that same ID's request date is populating as:
7/30/2019 8:52:22 PM
Sharepoint's regional time is set to UTC - 8:00, my computer is set to UTC - 8:00, and I am located in the same timezone.
The group I'm building this metric for is very excited that their data is showing they always work through the night! ha.
How can I get my timezone corrected?
Thanks!
-DK
5 Replies
I hope this helps.
I would need to look at your SharePoint and Power Bi time settings to find the cause.
- You have two options.
1. Use the DateTime.AddZone() function which adjusts for daylight savings
https://community.powerbi.com/t5/Service/Daylight-Saving-Time-with-weird-behavior/td-p/280413
Or
2. Create a custom column that takes the value of your date column and offsets it based on the month. This is not an elegant solution and is limited if you use multiple time zones.
Let me know if you need assistance with the second option; however, I strongly suggest using the first option.
