Forum Discussion
Advocate IIIConnection to SharePoint OData - what credentials are needed?
I've been given a report to troubleshoot where the error to fix is "the feed's metata data document appears to be invalid" -- but before I can work on that, I need to get access to the datasource. It seems like it should be a simple problem, but I'm really stumped.
The data source is an OData feed.
= OData.Feed("https://XXXXXX.sharepoint.com/sites/XXXXXX/_api/projectdata/"])
Constant 403 errors (forbidden). I've been given access to the SharePoint site and can navigate about it in a web browser. But that's apparently not enough for these feeds. I don't even know how to communicate up the organization what the permissions are that I need. Can anyone give me some advice?
Any help is appreciated.
Eventually we assigned the account 'Site Collection Administrator' to get this done.
Obviously, that's a very big club to hand a reporting account, and we will probably have to revisit the solution, but we need it working for now.
3 Replies
- trebgatte
Most Valuable Professional
I documented the process in this blog post. https://marqueeinsights.com/how-to-data-mine-a-sharepoint-list-with-power-bi/
Check it out and see if that fixes your issue. I recommend using the SharePoint List connector instead of the hand-crafted OData link since the Connector will do everything for you, including updating the OData string with filters, if you put your filter in the right place within Power Query.
Hope this helps!
--Treb, Power BI MVP
Check out our Power BI blog posts at https://marqueeinsights.com/category/power-bi/
V-lianl-msftCommunity Support
Hi RBunting ,Forbidden Error Generally occurs because of these two reasons1. Your Form Digest value is not correct.
2. The user you are running tests as doesn't have the requisite permissions.Try to log in with Microsoft account credentials and ignore your organization account that you have already signed into Power BI desktopBest Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RBuntingEventually we assigned the account 'Site Collection Administrator' to get this done.
Obviously, that's a very big club to hand a reporting account, and we will probably have to revisit the solution, but we need it working for now.
