"Access to the resource is forbidden." error showing while to Sharepoints Lists

[pra137]

Hello Guys, I am Trying to connect sharepoint Lists like GET DATA - SharePoint Online Lists , But I am unable to connect this, Power bi give me the error like We encountered error while trying to connect. Details :"Access to the resource is forbidden.". Please help me how to connect to the sharepoint list in Power Bi Thanks, PRA137

[V-pazhen-msft]

@pra137

Follow the tutorial from the doc: 

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-sharepoint-online-list

Incorrect credential can lead to that error, try edit the credential in the datasource setting.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pra137]

Thanks @V-pazhen-msft , I referred this tutorial before. sharepoint is connected to Power Bi But problem is we have created some lists/tables in the sharepoint I want to connect that Tables/Lists,But this tables/Lists are not show while connecting Sharepoint to Power BI..

Please help me how to connect lists of sharepoint to the Power BI.

[V-pazhen-msft · Accepted solution]

@pra137 

Which URL did you use? You must use the address of the Home Page of your SharePoint site. 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@pra137 , refer if these solutions can  help

https://community.powerbi.com/t5/Power-Query/Error-accessing-SharePoint-List-from-Power-BI-Desktop-q...

https://community.powerbi.com/t5/Desktop/quot-Access-to-the-resource-is-forbidden-quot-from-OneDrive...

https://community.powerbi.com/t5/Desktop/Error-quot-Access-to-the-resource-is-forbidden-quot-using-A...

You have to clear/edit permission and give them again

[pra137]

Thanks @ amitchandak for help. I did this but now it gives me this error Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed: OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Not Found) OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found) OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Not Found)" Thanks.