SQL Server 2012 (“Denali”): Power View installation and requirements

Power View is installed when you run the SQL Server 2012 install and on the Feature Selection page choose “Reporting Services Add-in for SharePoint Products”.  This is a newer version of the add-in that is installed with SharePoint 2010, with one of the new features being Power View.

The requirements to use Power View:

  • Power View is only available through SharePoint and requires Microsoft SharePoint Server 2010 Enterprise Edition
  • Reporting Services 2012 in SharePoint integrated mode
  • Microsoft Silverlight 5
  • Tabular model connection in SharePoint Server 2010
  • “Reporting Services Add-in for SharePoint Products” installed from SQL Server 2012 (Business Intelligence edition or Enterprise Edition) onto the SharePoint server you want to have Power View
  • Analysis Services 2012 for using a tabular mode server, or Analysis Service 2008/2012 for using a PowerPivot for SharePoint workbook

The tabular model connection can be any of these three ways:

1) Can be a PowerPivot for SharePoint workbook published in a PowerPivot Library View (Gallery, Theater, or Carousel) in SharePoint,

2) or a BISM report server data source (.rsds) type published in a SharePoint document library that connects to a database running on a SQL Server 2012 Analysis Services tabular mode server (which can use Windows authentication or stored credentials as Windows credentials),

3) or a BISM Connection File (.bism) published in a SharePoint Report Library (which has the BISM Connection File content type that is installed via these directions) in which the connection is pointing to:

  • a database running on a SQL Server 2012 Analysis Services tabular mode server (which can use only Windows authentication, not stored credentials, see Create a BI Semantic Model Connection to a Tabular Model Database)
  • a PowerPivot for SharePoint workbook (embedded PowerPivot databases inside Excel workbooks are equivalent to tabular model databases that run on a standalone Analysis Services tabular mode server).  You can use workbooks created in either SQL Server 2008 R2 or Microsoft SQL Server 2012 versions of PowerPivot for Excel.

Note you can also open this BISM Connection File in Excel as a ODC file (Excel opens a workbook that contains a PivotTable field list populated with fields from the underlying data source).

PowerPivot for SharePoint requires Excel services and requires you to install SQL Server PowerPivot for SharePoint (which installs a “PowerPivot for SharePoint” server mode in SSAS).  A benefit of the tabular model is that a PowerPivot for SharePoint model workbook can use many different data sources such as Microsoft Access, SQL Azure, SQL Server 2008, Excel file, text file, multidimensional database, etc. (a SSAS tabular cube is created behind the scenes).  The tabular model acts as a bridge between the complexities of back-end data sources and your perspective of the data.

Note that when the tabular model connection is using a PowerPivot for SharePoint workbook, you are using the saved data in that workbook and not hitting the source of that data.  For example, if you use a multidimensional database as a source for PowerPIvot, when you save the PowerPivot workbook to SharePoint you are using a static copy of the data from the multidimensional database that was pulled into PowerPivot.  When using Power View against this PowerPivot for SharePoint workbook, you are using that static data and not connecting to the multidimensional database.

If you wish to use option #1 above to start Power View, you would use PowerPivot to pull in data, then save the PowerPivot workbook to SharePoint (in the PowerPivot Gallery).  Then go to the PowerPivot Gallery in SharePoint, and next to the name of the PowerPivot workbook you will see a “Create Power View Report” control.  Click that and you are then able to create a Power View report off of a PowerPivot model.

To start Power View using options #2 or #3, you simply click the connection in the library or open its context menu and you will see the option “Create Power View report”.

Note that since Power View requires the tabular model, you can’t use Power View against multidimensional cubes (since multidimensional cubes do not support DAX queries and Power View uses DAX).  But it’s possible Microsoft will add support for this at a later date.

More info:

Deployment Checklist: Reporting Services, Power View, and PowerPivot for SharePoint

Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts

Comparison of Direct URL, BISM, and RSDS Data Connections for a Power View Report

About James Serra

James currently works for Microsoft specializing in big data and data warehousing using the Analytics Platform System (APS), a Massively Parallel Processing (MPP) architecture. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence/MDM architect and developer, specializing in the Microsoft BI stack. He is a SQL Server MVP with over 25 years of IT experience.
This entry was posted in Power View/Project Crescent, SQL Server 2012, SQLServerPedia Syndication. Bookmark the permalink.

8 Responses to SQL Server 2012 (“Denali”): Power View installation and requirements

  1. Pingback: SQL Server 2012 (“Denali”): Power View installation and … | Mastering Sharepoint

  2. Emil Glownia says:

    Hi James,

    Great post. It’s nice to have everything in one place.

    I’m preparing to use PowerView with SSAS Tabular model but installations is really quite dependant! Not sure if I will be able to do that on first attempt!

    Regards
    Emil

  3. amit says:

    Nice article Sir, can i use OLAP cubes, OLTP with Powerview. Please Respond

  4. amit says:

    But sir, this link (http://blog.webagesolutions.com/archives/584) says
    “As far as data source goes, Power View requires one of the following:
    Tabular Model (New in SSAS 2012)
    PowerPivot based Excel report (this could use OLTP, OLAP or Tabular Model)”.
    so this means we can use OLAP cubes and OLTPs also. Sir, i have one more query as i am a novice. what to do with report after creating it for e.g. lets say i made a powerview report now how can i view this. how can and where should i host this report and how and where can i publish it . can i schedule my reports like automatic mail to HR manager at 9:00 am in morning. Please respond. as i didnt get any link regarding that.

  5. Pingback: How to use a multidimensional cube with Power View | James Serra's Blog

  6. Omar Sultan says:

    Very helpful article thank you.

    I had a question, I am configuring an environment that will use Power View to connect to a Tabular Mode SSAS Instance.

    Do I need to install PowerPivot for SharePoint?

    Thanks

    • James Serra says:

      Hi Omar,

      Glad the post was helpful. I don’t believe you need to install PowerPivot for SharePoint in order to use Power View. I have never tried it, but I don’t see any dependencies. Let me know what you find out.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>