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

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

11 REPLIES 11
Thejeswar Senior Member
Senior Member

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.

 

aalfa Frequent Visitor
Frequent Visitor

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.

aalfa Frequent Visitor
Frequent Visitor

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

Thejeswar Senior Member
Senior Member

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

aalfa Frequent Visitor
Frequent Visitor

Re: SharePoint List Access to resource is forbidden

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

Thejeswar Senior Member
Senior Member

Re: SharePoint List Access to resource is forbidden

I am not sure about that...Smiley LOL

ToddChitt Member
Member

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. 

aalfa Frequent Visitor
Frequent Visitor

Re: SharePoint List Access to resource is forbidden

I always assumed Organizational Account was replaced by Windows Account. One in the same, no?
ToddChitt Member
Member

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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and 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.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 217 members 2,328 guests
Please welcome our newest community members: