You can use a Reporting Services report that has been published to a SharePoint site or a report server as a data source in a Power Pivot workbook. The following procedure describes how to create the connection to the report and import the data to your workbook. You must use a report definition (.rdl) file as a data source. More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.