Forum Discussion
Date Errors when loading Files from SharePoint folder into Power Query
I don't understand your response.
Read my answer again.
Look at what power query did to the first 3 dates. It switched the day and month. It didn't throw an error because they are still valid dates (even when switched).
This is quite a common issue (especially when importing dates from a transatlantic source)
Thanks HotChilli
I have cleared folder and only have 1 file which I load dated March 27,2021. File loads, but still getting the issue. Apparently there was a Windows update. I have reached out to some MVP's. GET DATA from SHAREPOINT folder addeding an API 15 parameter at end of M-CODE for source. It was suggested to remove this, which does remove date ERRORS but doesnt allow load. I changed the API 15 to 14 and same result. I have included details here
Hi EithneDangan ,
Pls check whether there are some extra space at the front of your date column,see the similar thread below:
Or refer below can help:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
