Forum Discussion
Connectivity: connecting to Excel file: Sharepoint folder vs Web
Hi DataChant / Gil,
I know how to use both of them, my question is rather if any of them have any benefits over the other one, so far the only difference i can really find is that going via the web connector could enable to move the file easier, but I am interested if there are any other benefits / drawback to using either of the connectors 🙂
And I am using 2 files, each with one table that gets refreshed every time, and one of the files contais 3 supporting tables, but they are only imported initilally as the value do not change.
Best,
Julius
Hi Julius,
Are the two files with the same format? If so, I would use the Folder connector to make the solution robust to append similar tabs together. IN the future, if you have three files of the same format, you would not need to make any change to keep the query refreshing.
The Share Point Folder option is slower because you first load folder details, and if you have many folders and files under the Share Point site, it can have an impact on the performance of the import. Nevertheless, I think that the impact is minimal compared to the sustainability you achieve with the folder approach, so I would go with the Folder approach.