Different date time between Power BI and Sharepoint

[saphirafira]

Hi, 

I have a data in Power BI and the source data is from Sharepoint list. 

And I just discovered that some of the date in Power BI are different from Sharepoint where user register their item manually by creating a new item in sharepoint while some of it are correct.

For example:

Date data in Sharepoint: 28/9/2023 12:00:00

Date data in Power BI: 27/9/2023 12:00:00

I checked the region settings in sharepoint and I used UTC for it. 

I already tried to change the timezone by changed it to local from the data type (UTC) and it's still not working, also tried this formula: 

DateTimeZone.SwitchZone(DateTime.AddZone([Date], 0), 1)

 It's still not working.

And I can't use AddDays function because some of the date are correct. If I use the AddDate the correct one will be the incorrect one. Also I can't use add duration because the date different is exactly 1 day. 

Is there any other solution for it? Your help will be so appreciated.. 

Thank you.

[christinepayton · Accepted solution]

I usually add hours, then convert to date, but not sure if that's the "best" way (there's issues with daylight savings that way, but people usually aren't creating records at midnight so you don't tend to notice). 

[amitchandak]

@saphirafira , refer if these settings can help

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