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…