Forum Discussion

Craig_01's avatar
Craig_01
Helper I
2 years ago
Solved

Sharepoint List Date Error

Hello,   I have a sharepoint list which  has a date/time column.. When i pull this into Power Bi to create some visuals my dates are showing wrong. I have a simple bar chart showing the quantity of...
Need Help
Show and Tell
  • christinepayton's avatar
    christinepayton
    2 years ago

    SharePoint stores the datetime in UTC, so you have to shift the time in PQ to match it back up with what you want. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi all,Thank you for your quick reply, I will add more.

Hi Craig_01 ,

As christinepayton  said, you need to create a new column with the time offset.

Something like this.(Assume my time difference from UTC is 2 hours)

[Date] + #duration(0,2,0,0)


Best Regards,
Wenbin Zhou