Forum Discussion
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 as 12/04/2023.
I've added a screenshot below:
Any ideas why the date is changing? The screenshot from Power query is at the first available step, so the data is importing incorrectly.
2 Replies
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...
