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:
|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 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.|
For detailed descriptions and configuration information for reporting properties, see Power View Reporting Properties (SSAS Tabular).
|Default Field Set|
In the model designer, in Data View, click a table (tab), or, in Diagram View, click a table header.
In the Properties window, click on a property, and then type a value or click the button for additional configuration options.