Sharepoint Folder Option

How to connect to sharepoint folder?
I need to connect to the folder itself so that whatever files coming inside folder gets appended automatically.
I am trying to provide the link, like
https://abc.sharepoint.com and is throwing error “Access to the resource is forbidden”(attached )
But if i mention the sub-folder like ,https://abc.sharepoint.com/def/hjjjjj the error is as attachedCapture%202Capture

Hello @Anu,

This connection type should work if you provide the site URL like

https://abc.sharepoint.com/def/

After that you can select the right folder in the Navigator.

Hope it helps.

Daniel

Hello Anu-
When this happened to me, it was due to a log-in credential issue. Here are a couple of resources that may be able to help you.

Thank you,
DT

Do you mean “/” in the end?

Hi @Anu,

Without the last “/”. I have made a typo :slight_smile:

Daniel

That is how I also provided.But not working

I am trying to connect to the SharePoint Folder for the fist time.
Its not in my existing data source list, because I have not even connected.
Im going to New Source – SharePoint Folder —Pasting the link and is throwing error while pasting…Attached screenshotCapture%203

Hi @Anu,

Could you display the complete link? Maybe you can blurr some parts.

Daniel

When you connect to a SharePoint folder, you can’t put the entire path. Only the root. So in your case, the site URL would start at https and end with .com.

If that doesn’t work – instead of going to Get Data --> SharePoint Folder, you could also try connecting via Get Data --> Web and pasting the entire URL there.

For both options if you still get the error message of “Access to the resource is forbidden.” you should reference the second link I previously sent you as this would indicate that the issue is credential related.

Thank you,
DT

So how to mention Subfolders?
https://abc.sharpoint.com/subfolder1/subfolder2 ?

My aim is to connect to the folder , so that I combine whatever files are coming in that folder(of same structure)

Once you successfully connect to the root URL, and get past the credentialing, you should be able to see all of the files from all of the folders that you have access to on that specific site.
https://powerbi.microsoft.com/pt-br/blog/combining-excel-files-hosted-on-a-sharepoint-folder/

If the above doesn’t work for your needs, I would suggest simply using the basic web connector and inputting the URL to your SharePoint folder.

1 Like

I tried using web.
Get data —Web—

these are different ways that I tried and the errors that I got
1.
Capture1
Capture2


Capture4


Yes, these are the credentialing issues that I expected you would have. Some of the links that I have previously shared may help to resolve these credentialing issues.

Thank you

I have read through both the links,

  1. I am already using Organizational Account to login as site is O365
  2. I am using latest version of Power BI
  3. The below method of clearing permission cannot be applied for me because I am not even able to connect to the site. And it doesnt appear in this list

Hi Anu-
I am not sure what else you can try. I will continue to research and will get back to you should I come across something. My apologies.

DT

It is not clear whether you tried connecting using “SharePoint Folder” by providing the URL to the root level of the site. Did you already try that? Once you establish the connection to the site, the data that is imported consists of a listing of all the files on that SharePoint site. You then use PowerQuery to filter that list down to the file(s) that you want to extract data from. After that, you use PowerQuery to extract the data from those files and manipulate that data as needed. It works perfectly, but it is not intuitive if it is the first time you have done it.

Yes ,I tried that


Capture12

I have seen in sites saying ,“Clear Permissions” for data source, But it is not even appearing in the data source list, coz this error occurs while trying to connect,