Forum Discussion
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...
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 Thanks for the links, these dont seem to solving my issue.
I have checked my sharepoint site & powerbi regional settings and they both match.. The sharepoint site is being populated by a power automate flow.. Not sure if this could be a factor.. However the dates are showing correctly in Sharepoint List..as 08/07/2024 00:00, however in power bi it shows as 07/07/2024 23:00... Which makes it look like the orders were recieved on the wrong day..
Any other suggestions.
Regards
Craig
SharePoint stores the datetime in UTC, so you have to shift the time in PQ to match it back up with what you want.