cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Colin_Broadspec Occasional Visitor
Occasional Visitor

Re: SharePoint List Access to resource is forbidden

The reason why Access was denied was due to user password change required by my organisation every 6 months

Once I reset my credentials with my new password all worked fine

michalinasta Frequent Visitor
Frequent Visitor

Re: SharePoint List Access to resource is forbidden

I have similar issue with the erros "Access to the resource is forbidden".

 

I was sucesfully using Power BI connected to the Sharepint folder (for 3 weeks) and yesterday I've opend Power BI desktop and after refreshing my Dashboard I've received this error.

 

I was trying to fix it by changing the microsoft password (it was suppose to expire in 11 days). I also logged in with organizational account and tried windows account as well. I even downloaded the newest version of Power BI Desktop. Nothing helped. The error occures while trying to refresh the data.

 

I'm the owner of this SharePoint folder. 

 

I would appreciate any support in this matter!

dilipreddygu Occasional Visitor
Occasional Visitor

Re: SharePoint List Access to resource is forbidden

  1. go to home
  2. edit queries
  3. Click on Data source Settings
  4. edit permissions
  5. give ur organisatio credentials
  6. good to go Smiley Happy
RamyaKanaka Frequent Visitor
Frequent Visitor

Re: SharePoint List Access to resource is forbidden

Hi,

 

My Password is all updated and I am using Organisational account to connect to the excel on sharepoint. But i am still getting "Access to resource if forbidden" error. Any help please?

 

Thanks,

Ramya

 


@james_k_apm wrote:

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


 

martusha Frequent Visitor
Frequent Visitor

Re: SharePoint List Access to resource is forbidden

I have the same issue. 

Logged into Power BI Desktop with my O365 account, however, I want to open on-premises SharePoint List as a data source. I place site URL, Windows login, but always got the error: Unable to connect. Details: "Access to the resource is forbidden."

Power BI desktop client updated to the latest version. 

Any other suggestions?

 

thanks,

Marta

michalinasta Frequent Visitor
Frequent Visitor

Re: SharePoint List Access to resource is forbidden

Hi,

 

thank you for your answer!

 

What helped was editing global permissions although the dashboard was using data sources in current file only. 

 

regards,

Michalina

Beat Regular Visitor
Regular Visitor

Re: SharePoint List Access to resource is forbidden

@Anonymous  I had this problem as well, when using Organizational Account I was able to sign in but then got an error "we couldn't sign you in with the current credentials". I had to delete all permissions and then edit credentials again for all data sources. Then I was able to apply changes.

JessWorkman Visitor
Visitor

Re: SharePoint List Access to resource is forbidden

Brilliant! Thank you. Worked 100% for me after searching for nearly an hour on this problem. 

ELAINEY Visitor
Visitor

Re: enable other user to refresh data

Hi Pros, 

Does anyone know how to enable my colleage to refresh data on Excel(within the Power BI services)? the data sources come from a file was saved on SharePoint.  We are using Office 365 rather than Power BI Desk, my colleage and I both can access to the SharePoint folder but when my colleage refresh data on Excel (Power BI), the error message shows: "[DataSource.Error]Could not find a part of the path:xxxxx." It looks like a file path access error, or a gateway for on-premises?

 

Does anyone got experiences on how to get data resources which enable other users to refresh data resource?

 

Thanks a lot

czalme Visitor
Visitor

Re: SharePoint List Access to resource is forbidden

This problem makes me crazy.  I run into all the time.  I never get to work in Power BI because I spend all my time just trying to get it. Then it gets put to the side for another six months -- I'm going on two years of this nonsense.  In February, I finally got a Microsoft expert to help me, we got in, by clearing the credentials.  I got in one other time and -- today -- the same problem has once again reared its ugly head  and I can't seem to get past it.  

 

  1. I'm trying to access a SharePoint list
  2. I've cleared all credentials as per my earlier instructions with Microsoft.  
  3. I choose Web
  4. I choose Organizational account 
  5. I paste my URL
  6. It says I'm not signed in
  7. I choose Connect and it says the current user isn't signed in. 
  8. I go back.
  9. There is the URL with basic selected
  10. I choose enter and it takes me back to Anonymous
  11. I choose Organizational account 
  12. This time I choose "Sign In"
  13. Tells me I'm being signed in
  14. I pick my organization account
  15. Takes me to my sign in page and does the authentication
  16. Now it says you are currently signed in -- which I have been all along and invites me to sign in as a different user. 
  17. Just for the heck of it, I select sign in as a different user and I get Access_denied: Access denied.  

 

This is infuriating and a huge waste of my time to keep using a process that does not work.  Any ideas???  Please????????????

 

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: 40 members 1,037 guests
Please welcome our newest community members: