Forum Discussion
Sharepoint Connector - Combine Data across multiple Excel Files
Thank you. I understand this, but the problem is my files (data) is not at the top subsite level, it is within a document library, and then two subfolders within that library. The problem, I believe, is that due to the enormous amount of files on our company sharepoint site, I reach a data limit and I cannot even get to the point where it finds the folder path that my files are located in (to be able to filter).
My solution that I have come up with is to create a 3rd tier subsite. Now, I can direct the query to go exactly to this subsite where my data will be located.
I find it frustrating as it seems this is a common complaint, but perhaps someday there will be a fix to be able to navigate directly to certain subfolders within Sharepoint.
Thank you. I understand this, but the problem is my files (data) is not at the top subsite level, it is within a document library, and then two subfolders within that library. The problem, I believe, is that due to the enormous amount of files on our company sharepoint site, I reach a data limit and I cannot even get to the point where it finds the folder path that my files are located in (to be able to filter).
My solution that I have come up with is to create a 3rd tier subsite. Now, I can direct the query to go exactly to this subsite where my data will be located.
I find it frustrating as it seems this is a common complaint, but perhaps someday there will be a fix to be able to navigate directly to certain subfolders within Sharepoint.
