Export (0) Print
Expand All

Table Properties (SSAS Tabular)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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:



Default Setting


Connection Name

<connection name>

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

To edit the connection, click the button.



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


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


Default Setting


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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft