Do you want to analyze SharePoint document libraries or lists? Then read Uday S. Unni’s excellent new SQL Server white paper about importing SharePoint list data into PowerPivot. It’s brief, it’s crisp, it’s to the point, covering common questions and typical issues. Look no further; this white paper has the answers!
- Software requirements for importing list data
- Examining list data in raw Atom format
- Importing all or selected lists from a SharePoint site by using a single data feed connection in PowerPivot for Excel
- Simplifying data import by using PowerPivot for SharePoint
- Troubleshooting common issues
For more information, please refer to the white paper “Using SharePoint List Data in PowerPivot” on MSDN at http://go.microsoft.com/fwlink/?LinkId=221005.