Get data from SharePoint Online

Question

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

I had tried get data from a Sharepoint Folder and also from Odata and enter the Sharepoint site URL However when I do this by entering https://xxxx.sharepoint.com/site/sitename I do not get a box asking for authorisation details and instead get "Access to the resource is forbidden".

Then I read some posts that told me to add the _vti_bin/listdata.svc at the end of the URL.

However 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.

jarrovgit · Answer

I noticed you have a URL containing '......com/site/...' while typically there should be something like this:

"https://<company>.sharepoint.com/sites/site/"

Without the qoutes and with the trailing slash ( / )

Let me know if that works

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

v-juanli-msft · Answer

Hi&nbsp;Anonymous&nbsp;
I would value the answer by&nbsp; djerro123.
Please look at my test example:

&nbsp;

Best RegardsMaggieCommunity Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;

anonymous · Answer

Thank you for you and&nbsp;v-juanli-msft&nbsp;`s reply.I am so sorry that it`s my typing miss and I do enter the URL as `sites`.&nbsp;

anonymous · Answer

Hi,Please try the below steps,Power Bi Desktop-Go to-File-Options &amp; Settings-Datasource Setting.First remove sharepoint credential from the list and again add share point site with below settings,Credentials:Organizational AccountPrivacy Level:noneThanks

anonymous · Answer

Hello，I had reset the data source as you said but the error message is as below.I am sure that I signed in in the same ID of the sharepoint, is there any possibility that the reason is because of the sharepoint permission?