Could not load file or assembly 'Microsoft.Data.Services, Version=126.96.36.199, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified.
Applies To: SQL Server 2016
In SharePoint 2010 environments that have Power Pivot for SharePoint, this error will occur if you attempt a data feed export and the system is missing the required version of Microsoft ADO.NET Data Services.
|Applies to||Power Pivot for SharePoint|
|Product Version||SQL Server 2008 R2, SQL Server 2012, SQL Server 2014|
|Cause||ADO.NET Data Services 3.5 SP1 was not found.|
|Message Text||Could not load file or assembly 'Microsoft.Data.Services, Version=188.8.131.52, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified|
SharePoint 2010 includes an Export as Data Feed button that you can use to export a SharePoint list as an XML data feed. In addition, both Reporting Services in SharePoint mode and Power Pivot for SharePoint support data feed features that require ADO.NET Data Services.
If ADO.NET Data Services is not installed, this error will occur when you request a data feed.
Go to the hardware and software requirements documentation for SharePoint 2010, Determine Hardware and Software Requirements (SharePoint 2010) (http://go.microsoft.com/fwlink/?LinkId=169734).
In Installing software prerequisites, find the link for ADO.NET Data Services 3.5 that corresponds to the operating system you are using.
Click the link and run the setup program that installs the service.