Forum Discussion
AlexJ01
Helper I
3 years agoIncorrect 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
Super User
3 years agoAlexJ01 , 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
- AlexJ013 years ago
Helper 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...