Forum Discussion
Date/Time issue
Hi everyone,
I'm getting data from a sharepoint list but for some reason my date/time values in power query are different.
Sharepoint:
Power Query:
Has anyone experienced this?
Hi ladurango ,
I want to validate the valuable input provided by sergej_og . Their initial thoughts helped guide my approach. However, I've noticed that more detail is needed to fully understand the issue.
The time in power query relates to your computer's local time, whereas the time in SharePoint relates to the site set's regional setting (time zone), and SharePoint will default to the time zone where the server is located.
SharePoint will default to the time zone where the server is located. SharePoint > Site Information in the Gear menu > All Site Settings > Regional Settings.
Here you can adjust the time zone to ensure that power bi and SharePoint are aligned.If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi ladurango ,
I want to validate the valuable input provided by sergej_og . Their initial thoughts helped guide my approach. However, I've noticed that more detail is needed to fully understand the issue.
The time in power query relates to your computer's local time, whereas the time in SharePoint relates to the site set's regional setting (time zone), and SharePoint will default to the time zone where the server is located.
SharePoint will default to the time zone where the server is located. SharePoint > Site Information in the Gear menu > All Site Settings > Regional Settings.
Here you can adjust the time zone to ensure that power bi and SharePoint are aligned.If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
