As I was asking in a related question, I'm trying to figure out how to get a PowerView report going that is using a SharePoint list as its data source.

In researching how that can be done, I found this q&a on the MSDN forums that says

Currently, Power View report only supports two types of data models: PowerPivot Worksheet, and data models based on Analysis Services Tabular Model or Multidimensional Cube.

In your scenario, you can create PowerPivot worksheets using SharePoint List as data source, deploy the PowerPivot worksheet to a SharePoint Library or PowerPivot Gallery, and then generate Power View reports based on the PowerPivot worksheets on the SharePoint site.

Great! One step closer. Then, in researching how to use a SharePoint list as a data source in PowerPivot in Excel, I found multiple articles that say that you have to go to the list you want to use, and click on a button called "Export as Data Feed", like this one and this one. I went to my list, and I don't see that button. In researching why that is the case, and how to enable the button, I found articles that say you have to activate the "PowerPivot Feature Integrations for Site Collections" site collection feature. I went to my site collection features, and the PowerPivot feature is enabled.

Then in digging even deeper to find out how everything needs to be configured, I found multiple places, including this MS whitepaper on the subject, and also this article, that say that in order for the data feeds to work, you need to install ADO.NET Data Services on the SharePoint WFE.

Ok, fine. But all those resources refer to SharePoint 2010, and everything they link to about ADO.NET Data Services say it's for .NET 3.5.

I'm trying to do this in SharePoint 2016, which is .NET 4.6, which brings us to my question:

Is there an ADO.NET Data Services for .NET 4.6?

Is there some equivalent, maybe with a different name?

How can I get the data feeds working in SP2016 so I can then use a SharePoint list as a data source for a PowerPivot worksheet, which I can then in turn use as a data source for a PowerView report?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.