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…
Perform What-If Analysis Within Excel using PowerBI
Sometimes you want to have a way to juggle numbers a little to perform quick what-if analysis, but you are not committed to the change at the time so you really don’t want to be changing the codes within Dynamics AX just yet, and would rather have the changes remain off-line until some time in the future.
In this example we will show you how to use an off-line worksheet that contains all of the changes that you want to make along with PowerPivot and PowerView to create a simple dashboard to track the impact that changes would have on your data.