Export (0) Print
Expand All

Table Properties (SSAS Tabular)


Applies To: SQL Server 2016

This topic describes tabular model table properties. The properties described here are different from those in the Edit Table Properties dialog box, which define which columns from the source are imported.

Sections in this topic:


PropertyDefault SettingDescription
Connection Name<connection name>The name of the connection to the table’s data source.

To edit the connection, click the button.
HiddenFalseSpecifies whether the table is hidden from reporting client field lists.
PartitionsPartitions for the table cannot be displayed in the Properties window. To view, create, or edit partitions, click the button to open the Partition Manager.
Source DataSource data for the table cannot be displayed in the Properties window. To view or edit the source data, click the button to open the Edit Table Properties dialog box.
Table DescriptionA text description for the table.

In Power Pivot for Excel, if an end-user places the cursor over this table in the field list, the description appears as a tooltip.
Table Name<friendly name>Specifies the table’s friendly name. The table name can be specified when a table is imported using the Table Import Wizard or at any time after import. The table name in the model can be different from the associated table at the source. The table friendly name appears in the reporting client application field list as well as in the model database in SQL Server Management Studio.

Reporting Properties

For detailed descriptions and configuration information for reporting properties, see Power View Reporting Properties (SSAS Tabular).

PropertyDefault SettingDescription
Default Field Set
Table Behavior
  1. In the model designer, in Data View, click a table (tab), or, in Diagram View, click a table header.

  2. In the Properties window, click on a property, and then type a value or click the button for additional configuration options.

Community Additions

© 2016 Microsoft