Date/Time issue

[ladurango]

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?

[Anonymous · Accepted solution]

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.

[sergej_og]

Hey @ladurango ,
looks like PQ converted your date/time value into UTC timezone value.
Is your timezone -6 hours to UTC timezone?

Regards