Database Reference
In-Depth Information
• SQL Server 2012 Analysis Services in multidimensional mode if using a
multidimensional model connection. It requires that SQL Server 2012
Service Pack 1 Cumulative Update 4 (CU4) be applied.
• SQL Server 2008/2012 Analysis Services in PowerPivot for SharePoint mode
if using a PowerPivot for SharePoint workbook.
• SharePoint Server 2010/2013 Enterprise Edition
Reporting Services Add-in
for SharePoint Products
installed from SQL Server 2012 onto the SharePoint
server on which you want to have Power View.
• Microsoft Silverlight 5.
Providing detailed instructions for installing all the software to support
Power View is outside the scope of this topic. For help with this, see the
Microsoft white paper titled
Power View Infrastructure Configuration and
Installation: Step-by-Step and Scripts
, which walks you through installing
and testing Power View and its infrastructure using multiple scenarios:
http://bit.ly/1bqaSZT
.
The data sources that Power View in SharePoint can use are a tabular model
connection or a multidimensional model connection (support for multidimensional
models was added after SQL Server 2012 was released via SP1 CU4).
Tabular model connection
The tabular model connection can be implemented in a number of ways:
• It can be a PowerPivot workbook (
.xlsx
) that is published to a SharePoint
site that has PowerPivot enabled (called PowerPivot for SharePoint). Once
published, the data is actually saved to a SharePoint PowerPivot flavor of the
tabular engine. You can then use a special-purpose document library called
PowerPivot Gallery to preview, share, and access published workbooks.
• It can be a BISM report server data source (
.rsds
) type that is published in a
SharePoint document library in which it connects to a database running on a
SQL Server 2012 Analysis Services tabular mode server (which can use either
Windows authentication or stored credentials as Windows credentials).
