Forum Discussion
Helper VImport sharepointlist: Wrong date: offset -1 day
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
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
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.
3 Replies
jochendecraeneamitchandak 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
Community Support
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
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.
