Table Properties

Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium

The properties described here are different from those in the Edit Table Properties dialog box, which define which columns from the source are imported.

Table properties

Basic

Property Default Setting Description
Connection Name <connection name> (Provider data sources) 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 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 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

Property Default Setting Description
Default Field Set
Table Behavior

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.