Forum Discussion
Connecting to SharePoint Folder error
Hi
I am having trouble connecting to a SharePoint Folder, I have searched the forums/web and nothing is working for me.
I am the Site Collection Admin of the SharePoint site in question which is an organisation "On premise" 2016 version of SharePoint. I have setup a document library that contains a number of excel documents that I require connection to. I know that I can connect using web to each individual document which I have done successfully many times but want to start using Folder option in case more data sources get added in future. I also successfully connect using SharePoint lists, it just seems to be the folder option that does not work. The error that displays is "Access to the resource is forbidden.” All recommended fixes including clearing credentials does not work for me. Am I missing something at the SharePoint end?
The version of Power BI I am running is Version: 2.66.5376.2521 64-bit (February 2019). I cannot update to a newer version as it gets released whenever the company decides to release it.
I eventually found a work around to the issue which works but isn't ideal.
I had to do the following (hopefully this helps others with the same issue).
1. Connect using SharePoint List to any list within the correct site. (using Windows credentials)
2. In query editor manually change the source code
from this:
= SharePoint.Tables("https://isharenew.company.com/sites/example_site", [ApiVersion = 15])
to this (red text):
= SharePoint.Contents("https://isharenew.company.com/sites/example_site", [ApiVersion = 14])
Then I just renamed the source from the original SharePoint list name I randomly selected in step 1 above to whatever I want it to be eg "SharePoint_Folder_1_Source"
If anyone could explain why I needed to do this work around that would be great because I would rather not have to do it!!
7 Replies
- Can you share the URL which you copied in the source
- Which authentication are you using?
- which privacy settings you are applying to?
Hi
1. https://isharenew.###.com/sites/sitename##/ (on premise 2016)
2. Windows (current credentials)
3. All privacy settings attempted.
These settings work for SharePoint lists and web connection in the same SharePoint site.
Try to enter your Windows credentials along with your domain name.
example- abc\username
Also, try OAuth 2.0 authentication.
