Forum Discussion
Connectivity: connecting to Excel file: Sharepoint folder vs Web
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.
Hi Gil (DataChant ),
Not quite,
I am using 2 excel files where
the first has a table filles with KPI's as well as 3 tables with suppproting data (used for calculations that do not change) and
the second one which has a number of locations and extra data to them, which is linked via a relationship in power bi, so i'm not using the combin function of the folder connector.
The quesiton is really just if the connectors have any benefit in terms of connecting to the file itself.
The only difference i have found so far is that the web connector could have the benefit that the file could be moved to another sharpoint site without havig to reconstruct the dashboard, but that does not seem likely at this point...
Best,
Julius