Import data from sharepoint folder fail

The folder connector is meant to combine a bunch of files with the same structure. Is that what you're trying to do here? Or are they different types of data for each file? 

The SharePoint folder connector wants the root site path (e.g. https://whatever.sharepoint.com/sitename ), not the file path. You can still connect using file paths to files stored in SharePoint, but not with the SP folder connector. My usual technique for the latter is to just use the desktop version of the connector and then go into the source step and paste in the cloud path (example here).