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
Advocate III've had this problem a few times and have always just done the following:
In Power BI desktop version, go File > Options and settings > Data source settings
Then, highlight the data source you are trying to connect to and select 'Clear permissions' and then select 'Delete'.
It's a pain having to do this, but I find it is a reliable way to get past the dreaded 'forbidden' message. Also, if other reports used the data source connection that you just deleted, when you open the report again you may well have to authenticate again.
Thanks ... this worked for me
This worked for me too.
Thanks JoeFox