cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
james_k_apm Frequent Visitor
Frequent Visitor

SharePoint List Access to resource is forbidden

Hi All,

 

I have googled for this issue but not seeming to find what might be causing this.

 

I am tying to connect to a SharePoint Online list via the Power BI desktop but keep getting an "Access to resource is forbidden" see below:

 

Power BI SharePoint List Error.jpg

I know my user credentials has access to the site, I am the site owner, is there anything else I should be looking at?

 

Cheers

 

James

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: SharePoint List Access to resource is forbidden

Hi @james_k_apm,

The above error could occur when using wrong log-in option to connect to SharePoint.

If your site is Office365, please enter organizational credential using the third option in the above screenshot. If your site is on premise, use Windows credentials as you mentioned. In addition, make sure that you use the latest version of Power BI Desktop.

For more details about connecting to SharePoint Online list from Power BI Desktop, please review this similar article: https://support.office.com/en-us/article/Connect-to-a-SharePoint-List-Power-Query-3226f248-f8b3-4777... .


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
21 REPLIES 21
Moderator v-yuezhe-msft
Moderator

Re: SharePoint List Access to resource is forbidden

Hi @james_k_apm,

The above error could occur when using wrong log-in option to connect to SharePoint.

If your site is Office365, please enter organizational credential using the third option in the above screenshot. If your site is on premise, use Windows credentials as you mentioned. In addition, make sure that you use the latest version of Power BI Desktop.

For more details about connecting to SharePoint Online list from Power BI Desktop, please review this similar article: https://support.office.com/en-us/article/Connect-to-a-SharePoint-List-Power-Query-3226f248-f8b3-4777... .


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
james_k_apm Frequent Visitor
Frequent Visitor

Re: SharePoint List Access to resource is forbidden

Thanks Lydia,

 

That was all I needed, once I used the Organisational Credentials it went through fine.

 

Cheers

 

James

Lima Frequent Visitor
Frequent Visitor

Re: SharePoint List Access to resource is forbidden

Hello, Lydia.

 

I'd have the same problem, but when I choose the option Organizational Account and try to log in with my credentials the message below appears: 

"invalid_request: AADSTS50000: There was an error issuing a token.
Trace ID: d33114c9-4316-4808-9dc5-7bb8f2536b2b
Correlation ID: 026993e0-7f5b-4831-bf0f-4984a9ddaa53
Timestamp: 2016-10-04 19:26:47Z."

 

Could you help me?

Highlighted
Lima Frequent Visitor
Frequent Visitor

Re: SharePoint List Access to resource is forbidden

accessforbidden.png

mdsolomon Frequent Visitor
Frequent Visitor

Re: SharePoint List Access to resource is forbidden

I also have this issue, for when connecting to an Excel workbook in OneDrive for Business, but seem to get the following error after I have tried to use Organizational account as suggested. The AAD log in popups up, (additionally the MFA goes through) and then it says connecting and it fails as below.

 

Unable to connect

We encountered an error while trying to connect.

Details: "The credentials provided cannot be used for the Web source. Please update the credential type through a refresh or in the Data Source Settings dialog to continue. (Source at <mysharepointsite/personal>)

 

Any ideas?

ToddChitt Member
Member

Re: SharePoint List Access to resource is forbidden

What if "Organizational Account" is not listed? My screen shows Anonymous, Windows, and Micrsoft Account as the three sections on the left.

 

FYI: I'm logged in to Power BI with my Organizational account, and I'm connecting to (ar attempting, anyway) a Sharepoint online site/list that requires my organizational account credentials.

skcary Regular Visitor
Regular Visitor

Re: SharePoint List Access to resource is forbidden

I had a somewhat similar problem. I was trying to connect to an Excel file I had saved on Sharepoint. I tried to connect using the "Sharepoint folder" option, but none of the different authentication methods I tried worked. @ToddChitt I had the same issue as you where I was not seeing an "Organizational Account" option.

 

I got it to connect after reading this post. What I did was use the Web connector and enter the full URL where the excel sheet was located (i.e. http://companyname.com/sites/sitename/foldername/filename.xlsx). Once I did that then the "Organizational Account" option appeared and I was able to connect to the excel file.

 

If you are trying to connect to a list I would try the same method, just change the URL to the site where the list is located and see if that works.

Untitled.png

 

kennethleung Occasional Visitor
Occasional Visitor

Re: SharePoint List Access to resource is forbidden

Having the same problem here. Using Get Data > Web, and providing the full path to the Excel file stored on SharePoint did not generate an Organizational Account option, and simply fails with "Access to a resources is forbidden".

Anonymous
Not applicable

Re: SharePoint List Access to resource is forbidden

You can reset your data connection by following below steps,

 

File --> Options & Settings --> Data source settings --> select your data source --> click on clear permission.

 

Now when you try to connect your data source such as sharepoint list, it will allow you to reneter your credential. select the 3rd option "Windows" while entering your credentials.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 105 members 1,630 guests