My connections only work when connecting to the root of the site I want to access. For example,
https://xyz.sharepoint.com/sites/mysite
My connections only work when connecting to the root of the site I want to access. For example,
https://xyz.sharepoint.com/sites/mysite
By mentioning sub folders you mean? And this is using SharePoint Folder option?
Hi @Anu,
DaveC is rightâŚ
In the Power Query Editor you will have to filter out the right folder in the column with the path. Itâs a little bit strange that the SharePoint folder connection doesnât accept the specific URL to the folder directly, but itâs just the way it is on this moment.
Daniel
There are no subfolders included in the URL. The sample URL I gave above is the root of that particular SharePoint site. A SharePoint site URL consists of the following:
Protocol: https://
Server: xyz.sharepoint.com
Sites Folder: sites
Site Root Level Folder: mysite
I guess you could call sites and mysite subfolders in the context of the server, but mysite is the root level folder of the SharePoint siteâusing my example, of course. Your URLs will be different, but the basic structure should be the same.
Hi @Anu, weâve noticed that no response has been received from you since February 02, 2020. We just want to check if you still need further help with this post? In case there wonât be any activity on it in the next few days, weâll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!