Microsoft Office Tutorials and References
In Depth Information
FIguRE 5-48 Some of Northwind’s tables imported in PowerPivot by means of a Data Feed.
Loading from SharePoint
SharePoint 2010 might contain several instances of data you would like to import into
PowerPivot. You cannot find a specific tool dedicated to importing data from SharePoint;
depending on the type of data or document you want to use, you can choose to use one of
the methods already shown.
This is a list of the most common data sources you can import from SharePoint:
■ Report A report generated by Reporting Services can be stored and displayed in
SharePoint. In this case, you follow the same procedure we described in the “Loading
from a Report” section of this chapter.