Forum Discussion
Import sharepointlist: Wrong date: offset -1 day
- 6 years ago
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.
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
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.