Forum Discussion
Getting data from on-prem sharepoint into Power BI Desktop
Thank you for the suggestion to use Fiddler, I am pretty sure my URL and credentials are correct as I can access other sub-pages of our corp (on prem) sharepoint site that have lists attached to them. I am not a sharepoint or windows person so I requested help with our admin to look into this, I will follow up with results.
thank you ..
I guess it would be worth noting when I clear all the source data permission settings the first time I access the root URL I get the error stating OData: The feed's metadata document appears to be invalid.
- Anonymous9 years agoNot applicable
brett_walton,
What version of SharePoint do you connect to? Do you use a custom OData implementation in SharePoint?
Regards,
Lydia- brett_walton9 years agoHelper II
We use Sharepoint 2013 and I am told we do not have any custom Odata implementations.
I will publish the fiddler findings once I get them.
Thank you,
Brett
- brett_walton9 years agoHelper II
We use Sharepoint 2013 and I am told we do not have any custom Odata implementations.
I will publish the fiddler findings once I get them.
Thank you,
Brett
- brett_walton9 years agoHelper II
Here is the trouble line from Fiddler.
<?xml version="1.0" encoding="utf-8"?><m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"><m:code>-1, Microsoft.SharePoint.Client.ResourceNotFoundException</m:code><m:message xml:lang="en-US">Cannot find resource for the request $metadata.</m:message></m:error>