Creating PowerView Reports From Analysis Services Cubes In Excel Using PowerPivot

Reblogged from Dynamics AX Tip Of The Day:

Click to visit the original post Click to visit the original post Click to visit the original post Click to visit the original post Click to visit the original post Click to visit the original post Click to visit the original post Click to visit the original post Click to visit the original post Click to visit the original post Click to visit the original post Click to visit the original post

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.


Read more… 271 more words

 •  0 comments  •  flag
Share on Twitter
Published on February 05, 2014 06:19
No comments have been added yet.