Forum Discussion
Connecting to SharePoint folder vs direct link
The folder connector is for when you're trying to load multiple files with the same data structure - e.g. a folder of CSVs where you add one CSV per month or similar. It starts its query at the site level, meaning it pulls all file info in the site, then you filter it down and expand the files... it creates a folder of helper queries to do the combination.
You can connect to single files individually if your data is not the same structure every time - that way you won't get the folder of helper queries and have to step through the site-level feed. You don't need a gateway for either one if you use the path of the file in SP Online.
The folder connector is for when you're trying to load multiple files with the same data structure - e.g. a folder of CSVs where you add one CSV per month or similar. It starts its query at the site level, meaning it pulls all file info in the site, then you filter it down and expand the files... it creates a folder of helper queries to do the combination.
You can connect to single files individually if your data is not the same structure every time - that way you won't get the folder of helper queries and have to step through the site-level feed. You don't need a gateway for either one if you use the path of the file in SP Online.