Power View - Reporting Properties

APPLIES TO: yesSQL Server Analysis Services yesAzure Analysis Services noPower BI Premium

Power View provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. They can easily create and interact with views of data from tabular models based on Power Pivot workbooks published in a Power Pivot Gallery, or tabular models authored by using SQL Server Data Tools (SSDT) and then deployed to SQL Server 2017 Analysis Services instances. Power View is a browser-based Silverlight application launched from SharePoint Server 2010 or later.

When authoring tabular model projects in SQL Server Data Tools, you can configure certain reporting properties unique to Power View reports. Topics in this section describe how to optimize a model to improve the reporting experience in Power View.

Topic Description
Configure Default Field Set for Power View Reports Describes how to configure a Default Field Set; a predefined list of columns and measures that are automatically added to a Power View report canvas when the table is selected in the report field list.
Configure Table Behavior Properties for Power View Reports Describes how to configure table behavior properties that expose detail rows at a more granular level. Setting table behavior properties changes the grouping behavior of detail rows and produces a better default placement of identifying information in tile, card, and chart layouts.