Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
I hope this helps.
I would need to look at your SharePoint and Power Bi time settings to find the cause.
So, our Sharepoint server I just found out is stored at 00 UTC. So whilte your solution isn't wrong, it just does not work for my needs.
Do you have a recommendation of a power query to offset time by a specific UTC that also takes daylight savings into account?
Hi @Anonymous ,
Have you solved the problem with the suggestion of Kjtakke ?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry