Issue importing OData feed in PowerPivot Model

[csnitish]

Hi,

i have a list in sharepoint which acts as my datasource for the application am working on, i can get data feed (OData) in the browser but when i try to import the data in powerpivot model it fails with the below error message. Please help me fix it.

============================
Error Message:
============================

Cannot connect to the specified feed. Verify the connection and try again. Reason: The remote server returned an error: (400) Bad Request.

============================
Call Stack:
============================

at Microsoft.AnalysisServices.Common.DataSourceBasic.UpdateDataFeedParameters(ConnectionStringBuilder connBuilder, IDataSource dataSource, Boolean checkFeedValid)
at Microsoft.AnalysisServices.Common.DataSourceBasic.GetCurrentConnectionString(Boolean checkFeedValid)
at Microsoft.AnalysisServices.Common.DataSourceBasic.ClickTestConnection(Object progressControl)

============================
=====================================================================================================

Image can be found in the below link

https://drive.google.com/file/d/0B7z-AK_iKVloVDdoWExoR3FZenM/view?usp=sharing



thanks in Advance,
Nitish.