Home > SSRS > Power View – Excel 2013

Power View – Excel 2013

I am really excited about this Excel 2013 – Power View feature. The most interesting, we can use it without SharePoint.
Here I would like to show a basic report development using this new Excel feature.
Step 1: Open Excel, In case Power Pivot and Power View are not enabled. Click on FILE (top left) option –> Options (bottom left)
Select Add-Ins –> Manage –> COM Add-ins and need to have these in the Add-ins as

Step 2: In DATA, Select from Other Sources, here I am using Analysis Services

Step 3: Give the Server details as

Step 4: Select Database and any model, here using existing AdventureWorks Tabular Model

Step 5: Just provide any properties for reusability of the connection

Step 6: Select Power View Report, it will directly launch the Power View report view in development mode

Step 7: Sample report developed using Power View and tested some common scenarios including slicers, Drill down etc.

Points to Consider:

1. Presented only a basic report creation using this Excel – Power View
2. We have alternative options of connecting to source data to develop Power View reports
3. Interesting, we can deploy this Excel workbook to SharePoint to share among end-users
4. To my understanding, this will reach many end users for ad-hoc reporting without thinking for any other 3rd party tools

Categories: SSRS Tags:
  1. Graham
    June 6, 2013 at 10:03 am

    Note that PowerPivot and Power View add-ins are not available in all versions of Excel 2013, you need Professional Plus or 365 Professional Plus

    • June 6, 2013 at 5:18 pm

      Graham, Thanks for your points and here I just tried to explore the options rather than discussing the compatibility model.

  1. No trackbacks yet.

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: