Connecting to SharePoint Folder error

[moomarine]

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.

[nandukrishnavs]

@moomarine 

1. Can you share the URL which you copied in the source
2. Which authentication are you using? 
3. which privacy settings you are applying to?

[moomarine]

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.

[nandukrishnavs]

@moomarine 

Try to enter your Windows credentials along with your domain name.

example- abc\username

Also, try OAuth 2.0 authentication.

[moomarine]

Still not working, i dont have OAuth 2.0 as an option either

[v-deddai1-msft]

Hi @moomarine ,

Would you please try to create a new pbix file and clear the Permission the data source of SharePoint you used before under Edit Queries>> Data source setting>>Global Permissions>> find the sharepoint source >> Clear Permissions.

And please refer to the similar thread: https://community.powerbi.com/t5/Desktop/Sharepoint-Folder/td-p/237546

Best Regards,

Dedmon Dai

[moomarine · Accepted solution]

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!!

[Anonymous]

Hi,

I had something similar.

I was getting the information through, but then at every refresh I would get the notification of an error. Then the error table was empty.

Inspired by your solution, I simply changed the ApiVersion from 15 to 14, using the "Advanced Editor" and it now works without error.

It might be some bug in the API, not sure how to flag it, since there is no error code, only the fact that an error occurred.