Creating PowerView Reports From Analysis Services Cubes In Excel Using PowerPivot

Dynamics AX Tip Of The Day

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: