I have recently setup a new query from Get Data to a SharePoint folder.
This is working fine other than the Date attributes having Errors. I have my Region Settings correctly set as English (United Kingdom). If I switch the settings to English (United States) then the Date columns populate correctly. However, understandably this causes issues for all my other queries.
As such, it looks like the SharePoint folder connector is not applying/using the Regional Settings and needs a tweak!