We're sorry OData Data Feeds can only be imported from the PowerPivot window if Microsoft .NET Framework 4.0 is installed. ...

We're sorry – OData Data Feeds can only be imported from the PowerPivot window if Microsoft .NET Framework 4.0 is installed. If you don't have it installed, you can get it from Microsoft .NET Framework 4 (Web Installer).

Alternatively, you can import Data Feeds into the data model from Excel. In Excel, go to the Data tab > From Other sources > From OData Data Feed. The data is then available to both Excel and PowerPivot.