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
You can reset your data connection by following below steps,
File --> Options & Settings --> Data source settings --> select your data source --> click on clear permission.
Now when you try to connect your data source such as sharepoint list, it will allow you to reneter your credential. select the 3rd option "Windows" while entering your credentials.
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