Forum Discussion
Sharepoint data issue
Strange. But you are not the first to experience it, there might be some pointers for you in this thread:
https://community.powerbi.com/t5/Desktop/SharePoint-date-differs-from-Power-BI-date/td-p/13856
Hi elmer ,
there are quite a few automatically updated date fields in a sharepoint list. Are you sure you are using the correct date field?
Cheers,
Sturla
hi sturlaws
Thanks for your reply!
I'm using the generic data field (the one that requires a manual insertion from a calendar) not a field that was automatically filled out by the system (like date of creation, etc...).
I am not able to reproduce this behaviour when importing data from a sharepoint online list.
Could you post some screenshots of what your data looks like, both in sharepoint and in power query?Hi sturlaws ,
here's some screeshot (I've got the italian version). In the sharepoint list the date is correct (I've tried the "automatically fill current date" option and it works), but in power bi it adds 1 day.
.
Strange. But you are not the first to experience it, there might be some pointers for you in this thread:
https://community.powerbi.com/t5/Desktop/SharePoint-date-differs-from-Power-BI-date/td-p/13856