MVC 4 WebApi with PowerPivot?

Question

Does anyone know if MVC 4 WebApi can (or will) be consumable in power-pivot?

Answer 1

Web API itself does not have built-in support for exposing endpoints in the OData format. We are planning on adding OData support via an add-on that will ship in the future.

Answer 2

I think if you expose an IQueryable<T>, it exposes it as a OData feed.

I found this.

http://codebetter.com/johnvpetersen/2012/03/22/bringing-odata-to-your-webapi-just-use-iqueryable/