Figure 1
Opening Power
View in a PowerPivot
Workbook
tabular source. If you decide to use an RDS file, make sure that you
set the Data Source Type property to Microsoft BI Semantic Model for
Power View. Otherwise, Power View will launch but won’t be able to
connect to the data source. Note that this property can’t be set in the
Report Designer environment. It must be set in the SharePoint data
source editor, as shown in Figure 2.
Figure 2
Setting the Data
Source Type Property
Tip 2: How to Easily Change Data Sources
You might occasionally need to change the data source used by a
Power View report. If the report is deployed in a PowerPivot Gallery,
you first need to switch the Library View from Gallery to All Documents. Next, click the drop-down arrow next to the report’s name and
www.SQLMag.coM
SQL Server Pro / May 2013
