Microsoft® SQL Server® 2012 Bible

1328

Part IX: Business Intelligence

Power View requires a SQL Server 2012 Reporting Services server confi gured in SharePoint

mode. Integration with SharePoint 2010 requires the Enterprise Edition of SharePoint.

Best Practices

Microsof t recommends applying Ser vice Pack 1 to SharePoint 2010 if you will be integrating SQL Ser ver

2012 BI features.

Client-Side Requirements

There are two main requirements on the client-side: A browser and the Silverlight version.

Power View is supported by Silverlight 5 and above in Internet Explorer, Firefox, and Safari.

Table 59-1 lists the browser versions supported by Power View.

TABLE 59-1 Power View Browser Support

B rowser Browser Version

Internet Explorer v7, v8, v9 32-bit, and 64-bit

Firefox v7 32-bit

Safari v5 32-bit and 64-bit

Power View does not support the InPrivate browser feature of Internet Explorer.

Creating and Deploying Reports with Power View

You can launch Power View from a data source containing a BI Semantic Model published to

SharePoint 2010. There are fi ve options to launch Power View:

1. Directly from a PowerPivot workbook (.xlsx fi le) in PowerPivot Gallery


2. From a Report Data Source (.rsds fi le) pointing to a PowerPivot workbook


3. From a Report Data Source (.rsds fi le) pointing to an Analysis Services Tabular
   database


4. From a BI Semantic Model connection (.bism fi le) pointing to a PowerPivot
   workbook


5. From a BI Semantic Model connection (.bism fi le) pointing to an Analysis Services
   Tabular database

c59.indd 1328c59.indd 1328 7/31/2012 10:37:04 AM7/31/2012 10:37:04 AM

http://www.it-ebooks.info