Import sharepointlist: Wrong date: offset -1 day

[jochendecraene]

Hi,

I've imported data form a sharepoinlist.

The dates in the sharepointlist start on march 23; but when I import in to power bi, the date starts on march 22.

I've checked the options in both the sharepointlist and power bi and they are correct for my regio/timezone (Amsterdam)

Any ideas what is going on and how I can solve this?

Jochen

[amitchandak · Accepted solution]

@jochendecraene , refer if these can help

https://sharepoint.stackexchange.com/questions/264660/sharepoint-date-wrong-in-power-bi
http://geekswithblogs.net/darrengosbell/archive/2019/02/01/power-bi-ndash-fixing-dates-from-sharepoi...

[amitchandak · Accepted solution]

@jochendecraene , refer if these can help

https://sharepoint.stackexchange.com/questions/264660/sharepoint-date-wrong-in-power-bi
http://geekswithblogs.net/darrengosbell/archive/2019/02/01/power-bi-ndash-fixing-dates-from-sharepoi...

[jochendecraene]

@amitchandak thnx, but this does not solve the problem

the dates in both the sharepointlist and the data in power bi, are in my local timezone

[v-easonf-msft · Accepted solution]

Hi , @jochendecraene 

It usually occurs when  user has different time zone other than SharePoint Time Zone

It seems that powerbi currently returns dates from SharePoint items in UTC, unless you apply a transformation.

I will suggest you to converted the date time values to your home time zone  by adding offset  hours to UTC date time values.

You may check if the following posts help.

https://community.powerbi.com/t5/Desktop/TimeZone-problems/td-p/171245

https://community.powerbi.com/t5/Desktop/Wrong-date-from-SharePoint-List/td-p/712659

https://community.powerbi.com/t5/Desktop/SharePoint-date-differs-from-Power-BI-date/td-p/13856

http://geekswithblogs.net/darrengosbell/archive/2019/02/01/power-bi-ndash-fixing-dates-from-sharepoi...

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.