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
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
Super UserWhat if "Organizational Account" is not listed? My screen shows Anonymous, Windows, and Micrsoft Account as the three sections on the left.
FYI: I'm logged in to Power BI with my Organizational account, and I'm connecting to (ar attempting, anyway) a Sharepoint online site/list that requires my organizational account credentials.
I had a somewhat similar problem. I was trying to connect to an Excel file I had saved on Sharepoint. I tried to connect using the "Sharepoint folder" option, but none of the different authentication methods I tried worked. ToddChitt I had the same issue as you where I was not seeing an "Organizational Account" option.
I got it to connect after reading this post. What I did was use the Web connector and enter the full URL where the excel sheet was located (i.e. http://companyname.com/sites/sitename/foldername/filename.xlsx). Once I did that then the "Organizational Account" option appeared and I was able to connect to the excel file.
If you are trying to connect to a list I would try the same method, just change the URL to the site where the list is located and see if that works.
Having the same problem here. Using Get Data > Web, and providing the full path to the Excel file stored on SharePoint did not generate an Organizational Account option, and simply fails with "Access to a resources is forbidden".
Brilliant! Thank you. Worked 100% for me after searching for nearly an hour on this problem.
