Exposing an Excel PowerPivot model as a Web Service

In my last post I demonstrated a simple way to interrogate an Excel based PowerPivot model using either MDX,DMV or the new DAX Query Table commands. This is a great way to dig deep into a PowerPivot model, for example, this new Denali DMV discover_calc_dependency can be use to describe the dependencies between a model's DAX measures.

Being able to directly access the PowerPivot model opens up all sorts of interesting options, one such is a web service.