Sharepoint Folder Option

Power BI
21

My connections only work when connecting to the root of the site I want to access. For example,

https://xyz.sharepoint.com/sites/mysite
22

By mentioning sub folders you mean? And this is using SharePoint Folder option?

23

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

24

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.

25

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!