Reply
Frequent Visitor
Posts: 16
Registered: ‎05-26-2017

SharePoint List Access to resource is forbidden

I have been through the whole internet looking for a solution to this problem, but it doesn't seem like there is a tried and true way to fix it. Once a month, my Power BI Dashboards seem to not be able to refresh when they are connected to a SharePoint list. I have the correct access to the SharePoint lists and I even go through an MFA verification process when trying to refresh. The reports refresh fine and then I get the error message in the subject title at the end of the month. Here's a list of things I have tried that have worked in the past but do not work consistently:

 

- Clear permissions in Power BI (local file/global)

- Accessing my company's VPN 

- Clearing my internet cache

- Changing the hierarchy of the site I want to connect to in the refresh

- Doing the refresh through the Query Editor screen

 

 

This inconsistency is really causing a hassle for me and the teams I create these dashboards for. Can anyone please tell me what is going on?

 

Thank you,

Alex

Senior Member
Posts: 317
Registered: ‎12-04-2017

Re: SharePoint List Access to resource is forbidden

Hi @aalfa,

BTW what is the error that you are getting?

Is your report a monthly refresh report or a daily/weekly refresh that fails only once a month?

 

We have reports built on Sharepoint list and they don't seem to get this issue.

 

Frequent Visitor
Posts: 16
Registered: ‎05-26-2017

Re: SharePoint List Access to resource is forbidden

2018-06-28_7-58-28.jpg

 

Hi @Thejeswar, the error message is shown above.

There is no scheduled refresh - it is done manually through the Power BI Desktop version.

 

It seems like everyone using SharePoint lists at my firm is running into the same issue, even when using OData feeds.

Frequent Visitor
Posts: 16
Registered: ‎05-26-2017

Re: SharePoint List Access to resource is forbidden

After the refresh fails and I click cancel - this is the message I receive. I have full access to all these SharePoint sites and I have gone through our Company's MFA verification. I have also gone through clearing and updating my permissions in the Data Source settings.

 

2018-06-28_8-08-53.jpg

Senior Member
Posts: 317
Registered: ‎12-04-2017

Re: SharePoint List Access to resource is forbidden

@aalfa,

Are you able to access the sharepoint list online in the site location where it is present.

 

If there is some issue with your access to the sharepoint list, even there you shouldn't be able to access the list. If you ar not able to access it online, then fix your access there. That should solve the issue....

 

If you are able to access the sharepoint list in the location where it is present online, then I think you should raise a ticket with Microsoft (as you say that all in your company is facing this issue) stating your issue

Frequent Visitor
Posts: 16
Registered: ‎05-26-2017

Re: SharePoint List Access to resource is forbidden

@Thejeswar Do I really have to pay Microsoft to open a ticket?

Senior Member
Posts: 317
Registered: ‎12-04-2017

Re: SharePoint List Access to resource is forbidden

I am not sure about that...Smiley LOL

Member
Posts: 78
Registered: ‎07-10-2015

Re: SharePoint List Access to resource is forbidden

I get the same error. But look at the screen shot: The three types of authentication methods are: Anonymous, Windows, and Microsoft Account. Same as what I see. 

What is missing is Organizational Account. 

 

Assuming this is work related, and that you have O365 for your SharePoint online site, one would assume that "Organizatinal Account" would be an option here. But it's not. Solve THAT and I bet you can get in.

 

If you find out how, please let us know. 

Frequent Visitor
Posts: 16
Registered: ‎05-26-2017

Re: SharePoint List Access to resource is forbidden

I always assumed Organizational Account was replaced by Windows Account. One in the same, no?
Member
Posts: 78
Registered: ‎07-10-2015

Re: SharePoint List Access to resource is forbidden

I think under the covers, a Microsoft Account is NOT the same as an Organizational Account, seeing as they used to make you specifiy between the types BEFORE you entered any credentials. In one case Microsoft holds the password, and in another, it is held by your organization.

But now they just SHOW you the one type, when in fact you can put in or Org credentials there and make it work. It was a stumbling block for me as the account I wanted to use was moste definitely NOT a Microsoft Account as the SharePoint site was from our O365 tenant.

 

For me, choosing Microsoft Account as the type, then entering my Org creds did the trick. 

 

Just with the user experience was a little better Smiley Sad