Forum Discussion
SharePoint List Access to resource is forbidden
- Anonymous10 years ago
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-82ce-b4ed04dedaaf?ui=en-US&rs=en-US&ad=US .
Thanks,
Lydia Zhang
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.
- I'm trying to access a SharePoint list
- I've cleared all credentials as per my earlier instructions with Microsoft.
- I choose Web
- I choose Organizational account
- I paste my URL
- It says I'm not signed in
- I choose Connect and it says the current user isn't signed in.
- I go back.
- There is the URL with basic selected
- I choose enter and it takes me back to Anonymous
- I choose Organizational account
- This time I choose "Sign In"
- Tells me I'm being signed in
- I pick my organization account
- Takes me to my sign in page and does the authentication
- Now it says you are currently signed in -- which I have been all along and invites me to sign in as a different user.
- 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????????????