Forum Discussion
Get Data "From Folder" from Sharepoint Folder
Hi CraigSchulz
After researching, i haven't found any way to connect directly to Sharepoint Folder as you described.
A well-known way is using "Sharepoint Folder" connector and selecting your desired folder from the displaying list of folders' path.
Combining Excel Files hosted on a SharePoint folder with Power BI
After we connect to sharepoint successfully, we’ll be able to see all of the files from all of the folders that we have access to in that specific site.
This might be a pretty long list, so let’s do some filtering on the “Folder Path” column and select the folder where your data is being stored so you only get the files from it.
Best Regards
Maggie
Hi CraigSchulz
After researching, i haven't found any way to connect directly to Sharepoint Folder as you described.
A well-known way is using "Sharepoint Folder" connector and selecting your desired folder from the displaying list of folders' path.
Combining Excel Files hosted on a SharePoint folder with Power BI
After we connect to sharepoint successfully, we’ll be able to see all of the files from all of the folders that we have access to in that specific site.
This might be a pretty long list, so let’s do some filtering on the “Folder Path” column and select the folder where your data is being stored so you only get the files from it.
Best Regards
Maggie
This GET FULL FILE LIST > FILTER FILE LIST BY FOLDER NAME process works for me.
Had the same issue. However, my site wasn't xxx.sharepoint but rather share.xxx.
My "Solution" was by mapping a network drive to the location you want. Then refer to this drive. It is not fool proof, but it does the trick. I haven't found a way to fix it without an intermediar.
