Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
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.
Sounds like a permissions issue. Which connector are you using?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |