Getting data from SharePoint Online?

[GarethWoodhouse]

I have an excel online file stored in a sharepoint 365 document library.

I have read a few posts that said I should get data from a Sharepoint Folder and enter the Sharepoint site URL However when I do this by entering https://<companyname>.sharepoint.com/sites/<sitename>/  I do not get a box asking for authorisation details and instead get "Access to the resource is forbidden".

Am I doing something wrong or do we think it's a Sharepoint permissions thing?

Thanks.

[v-frfei-msft · Accepted solution]

Hi @GarethWoodhouse,

Based on my test, we can connect to SharePoint online list use OData feed to work aorund, we need to append _vti_bin/listdata.svc at the end of site URL. For example, the URL of the SharePoint online list is this: https://xxxx.sharepoint.com/teams/test/Lists/list01, then we need to specify the OData URL like this:

Regards,

Frank

[Anonymous]

excuse me, but I had the same trouble with GarethWoodhouse. 

When I use the _vti_bin/listdata.svc behind https://xxxx.sharepoint.com/site/sitename/Lists/list01 by Odata，the message is like below:

Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (400) Bad Request. (Bad Request)
OData Version: 4, Error: The remote server returned an error: (400) Bad Request. (Bad Request)
OData Version: 3, Error: The remote server returned an error: (400) Bad Request. (Bad Request)"

And if I use this behind https://xxxx.sharepoint.com/site/sitename/  the message still showing "Access to the resource is forbidden."

Is it because that I didn't signin to the PowerBI Desktop or is there something I had done wrong?

Thanks.

[Greg_Deckler]

Sounds like a permissions issue. Which connector are you using?

[GarethWoodhouse]

Using the SharePoint Folder connector.

I assumed that was the one to go for given what I need isn't in a sharepoint list.

I'll speak to someone internally here to see if we can poke around in the SharePoint permissions.

Thanks.