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…
View original post 253 more words
Share this post