O'Reilly logo

Microsoft SQL Server 2012 Bible by Aaron Nelson, Jose Chinchilla, Patrick LeBlanc, Jorge Segarra, Adam Jorgensen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 five options to launch Power View:

1. Directly from a PowerPivot workbook (.xlsx file) in PowerPivot Gallery
2. From a Report Data Source (.rsds file) pointing to a PowerPivot workbook
3. From a Report Data Source (.rsds file) pointing to an Analysis Services Tabular database
4. From a BI Semantic Model connection (.bism file) pointing to a PowerPivot workbook
5. From a BI Semantic Model connection (.bism file) pointing to an Analysis Services Tabular database

The PowerPivot Gallery in SharePoint 2010 enables you to launch Power View directly from a PowerPivot workbook (.xlsx file), as shown on Figure 59.1.

Figure 59.1 Launching Power View from PowerPivot workbook in PowerPivot Gallery.

59.1

You can also launch Power View from a shared data source with a Microsoft Business Intelligence Semantic Model data source type, based either on a PowerPivot file or a tabular model database on an Analysis Services server from any library. Shared data sources have a file type extension of .rsds.

The next section walks you through the steps to create a document library that supports Semantic Model data source connection files. The sections that follow walk you through the steps to create Report Data Source files and BI Semantic ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required