Forum Discussion
AlexJ01
3 years agoHelper I
Incorrect Date from Sharepoint list
Hi all, I've got data pulling from a Sharepoint list, but the date values in PowerBi are off by 1 day. For example, I have a due date of 11/04/2023 in my Sharepoint list, but in PowerBi it shows ...
amitchandak
3 years agoSuper User
AlexJ01 , refer: https://sharepoint.stackexchange.com/questions/264660/sharepoint-date-wrong-in-power-bi
https://community.powerbi.com/t5/Desktop/SharePoint-Date-Data-getting-changed-in-Power-BI/m-p/736429
AlexJ01
3 years agoHelper I
Thank you for your reply. Technically that does solve the issue, but changing from API 15 to API 14 breaks the rest of my query so it's not helpful in this instance. I've ended up creating a calculated column to +1 to the date so that it is correct. This is is very annoying bug...