Forum Discussion
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-82ce-b4ed04dedaaf?ui=en-US&rs=en-US&ad=US .
Thanks,
Lydia Zhang
After I change windows login password, this happened to me.
Windows login password change will update login information to Office365 Apps and Power BI desktop as well.
But it does not update login information from Power BI desktop to your sharepoint site.
1. File - Options and settings - Data source settings
2. (select the data source) Edit permissions... - Edit
3. Select Microsoft Account (because I login to sharepoint using Microsoft Account, Office365)
4. You will see your login condition just below site address. Press Sign in button just below it.
5. After sign in, save and close.
6. If you have multiple connections, you have to do it for all connections.
I hope this solve your problem.
Well done mate, worked like a charm.