Enhancing data models
As mentioned in the previous sections, possible data sources for Power View are a PowerPivot for SharePoint workbook or an Excel 2013 data model. Both allow you to view and edit the data models in PowerPivot while in Excel. A benefit is that it allows you to make enhancements to the data model before users start to create reports against it in Power View. The enhancements can also be made to a tabular model via a Tabular Analysis Services project in SQL Server Data Tools (SSDT).
The following are some of the enhancements you can make:
Default Field Set: This setting is used for a table and gives you the ability to select default columns and measures and define the preferred order. Then, these columns and measures are automatically added to the Power View report canvas when you create a report and click on the table name displayed in the field list in Power View. This will help to reduce redundant steps when using a data model in a report. To set the default fields for...
