Creating PowerView Reports From Analysis Services Cubes In Excel Using PowerPivot

If you have ever tried to create a PowerView report within Excel that is populated directly from an Analysis Services Cube, then you may have come across a small roadblock where PowerView refuses to work.  All is not lost though, you can trick Power View into thinking that it is querying a real table by using PowerPivot to craft the query first.

The only downside to this is that we don’t have to use PowerQuery as much any more…