Share via

Table Properties (SSAS Tabular)

  • Article

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:

  • Table Properties

  • To configure table property settings

Table Properties

Basic

Property

Default Setting

Description

Connection Name

<connection name>

The name of the connection to the table’s data source.

To edit the connection, click the button.

Hidden

False

Specifies whether the table is hidden from reporting client field lists.

Partitions

Partitions 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 Data

Source 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 Description

A text description for the table.

In PowerPivot 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).

Property

Default Setting

Description

Default Field Set

Table Behavior

To configure table property settings

  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.