We're sorry Data from Microsoft SQL Server Reporting Services reports can only be imported from the PowerPivot window if ...

We're sorry – Data from Microsoft SQL Server Reporting Services reports can only be imported from the PowerPivot window if Microsoft .NET Full Framework 4.0 or higher is installed. Alternatively, you can import Reporting Services reports into the data model from Excel using the Data Feed option. In Excel, on the Data tab, click From Other Sources, and then click From OData Data Feed. The data should now be available to both Excel and PowerPivot. You can download the Microsoft .NET Full Framework 4.0 here:
http://go.microsoft.com/fwlink/?LinkId=243132