Forum Discussion
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 orders recieved each day.. with the date being along the x-axis.. However if the order date is 04/07/2024.. This is showing in powerbi as 03/07/2024.. How do i fix this?
Date in SharepointList is showing correctly.
Thanks
SharePoint stores the datetime in UTC, so you have to shift the time in PQ to match it back up with what you want.
4 Replies
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.
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
