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.
Hi Anonymous
To connect to Excel Files hosted on a SharePoint folder with Power BI,
From the Get Data experience, let’s find the option for “SharePoint Folder”.
This option will only require a text string which would be the URL for a SharePoint site.
In order to use the correct URL, we need to be in the folder of the data that we’re trying to get and check the url that our browser shows.
If it has the if it starts with the format of https://<site address>/sites/<sitename>/ then we need to use that url, otherwise we use the much simpler https://<site address>
Best Regards
Maggie
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.
- can you elaborate how you create subsite, i am facing similar issue while accessing the sub folder in sharepoint
