PowerPivot can't connect to OData WebAPI

2019-06-08 01:31发布

问题:

When I try to connect to my localhosted Odata WebAPI from Excel 2010 PowerPivot I got 404: Not found error.

Actually, PowerPivot can explore the list of my endpoints and says that connection successful. But when I press Finish button it shows 404.

Strange, but Fiddler captures nothing!

Please suggest. Thank you!