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
I also have this issue, for when connecting to an Excel workbook in OneDrive for Business, but seem to get the following error after I have tried to use Organizational account as suggested. The AAD log in popups up, (additionally the MFA goes through) and then it says connecting and it fails as below.
Unable to connect
We encountered an error while trying to connect.
Details: "The credentials provided cannot be used for the Web source. Please update the credential type through a refresh or in the Data Source Settings dialog to continue. (Source at <mysharepointsite/personal>)
Any ideas?