Forum Discussion

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
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.

amitchandak

Super User

2 years ago

Craig_01 , refer to these past solutions

https://community.fabric.microsoft.com/t5/Service/SharePoint-Date-Data-getting-changed-in-Power-BI/m-p/2221404

https://community.fabric.microsoft.com/t5/Desktop/Date-Change-from-Sharepoint-to-Power-BI/td-p/3258152

Forum Discussion

Sharepoint List Date Error

Related content

Sharepoint list mirroring

PBI Desktop and SharePoint List Refresh Error

Sharepoint List Importing Problems

OData Error When Connecting to SharePoint Online

Mirrored SharePoint List (Preview) - “Failed to get document libraries” Error 404