Forum Discussion
Date Errors when loading Files from SharePoint folder into Power Query
Hello everyone. I would love some help. I am using powerquery to load files from a SharePoint folder. Any files uploaded since March 17th (St. Patricks Day - Luck of the Irish!) are coming in w...
This is a bug being investigated by Microsoft
EithneDangan and I investigated further and changing the SharePoint.Files step to use SharePoint.Contents and drill down to the relevant folder avoided the issue highlighted by HotChilli with US date formatting
Hope that helps someone else
Cheers
Wyn