993bc7a2__Chris_Webb_s_BI_Blog___Page_2__0
[1] Create data sources and then datasets to return the data you want [2] Import data into PowerPivot ‘tables’ from Excel, RDBMSes, OData feeds [3] There’s a slight difference between the data sources here, but the most important case is always going to be getting data from a RDBMS, which both do well. The key difference, though, is that in general with SSRS you get data on demand through parameterised queries, whereas with PowerPivot you import all the data you’re ever likely to need up front. [0] 
Get data from a number of different sources
Random Thoughts | Chris Webb's BI Blog | Page 2
0