Access to the resource is forbidden. trying to load subsite list from sharepoint online

[cb1544]

Hi,

I want to get the data from a sharepoint online subsite list.

When I try to load the data using the root link, it works fine but using the root link ,I can't get the data from the lists in the subsite.

Unfortunatly when I use the susbite link to load the data I got this Error :

Unable to connect

We encountered an error while trying to connect,

Details: "Access to the resource is forbidden."

Can you help me please to get the data from the subsite lists ?

Thanks !

Best,

Camelia

[v-juanli-msft · Accepted solution]

Hi @cb1544 

Check the link

https://www.blue-granite.com/blog/power-bi-office-hours-sharepoint-files-lists-folders

Link used in the connection should be format as below

I make a test as below,

I have a site named 11.15, to connect to this site, i enter the link 

https://****.sharepoint.com/sites/1115

Best Regards
Maggie

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

[cb1544]

Thank you Maggie