Sharepoint List Date Error

[Craig_01]

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

[Anonymous]

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

[amitchandak]

@Craig_01 , refer to these past solutions

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

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

[Craig_01]

@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

[christinepayton · Accepted solution]

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