Tabular Column

The Columns section lists the columns that belong to the table in the model. Each entry specifies the source column name and its data type, which is crucial for defining how data is stored and manipulated within the model.

Dax Column

Name	Description
SourceColumn	Sourcecolumn name, if name is not supplied, this name is used. Automatically camelcase script is applied.
DataType	Datatype of the column. Will be converted to Fabric datatype.
Classification	Classification of this field. Set to sensitive for fields that should be handled with care.
DataCategory	Data category of the column
Description	Description of the field, used in BI-tools like Power BI and Excel
DisplayFolder	Folder for this field, used in BI-tools like Power BI and Excel
FormatString	Format string of this field
IsHidden	Field is hidden from the model (can still be queried) (default=false)
IsKey/IsPrimaryKey	Field is used as the primary key for this table (default=false)
IsUnique	Field contains unique values (default=false)
OrderByColumn	The field on which this field should order.

Basic: SourceColumn and Type

- Table:
    Name: CallStatus
    SourceTable: D_CallStatus
    TableType: Dim
    Columns:
    - SourceColumn: CallGrouping
      Type: varchar(50)
    - SourceColumn: PhoneStatus
      Type: varchar(50)
    - SourceColumn: IsActive
      Type: bit

• SourceColumn: This is the name of the column in the source data.
• Type: Indicates the data type of the column. This defines how the data is stored and processed within the model. For a comprehensive list of data types, visit all data types.

Common Column Example

- Table:
    Name: CallStatus
    SourceTable: D_CallStatus
    TableType: Dim
    Columns:
    - SourceColumn: CallGrouping
      Type: varchar(50)
      Description: Represents the grouping of calls.
    - SourceColumn: PhoneStatus
      Type: varchar(50)
    - SourceColumn: IsActive
      Type: bit
      IsHidden: true

Classification

- Table:
    Name: CallStatus
    SourceTable: D_CallStatus
    TableType: Dim
    Columns:
    - SourceColumn: CallGrouping
      Type: varchar(50)
      Classification: Sensitive
    - SourceColumn: PhoneStatus
      Type: varchar(50)
    - SourceColumn: IsActive
      Type: bit

• Classification: This field designates whether the data is classified as sensitive and should be handled with care.

Description

- Table:
    Name: CallStatus
    SourceTable: D_CallStatus
    TableType: Dim
    Columns:
    - SourceColumn: CallGrouping
      Type: varchar(50)
      Description: Represents the grouping of calls.
    - SourceColumn: PhoneStatus
      Type: varchar(50)
    - SourceColumn: IsActive
      Type: bit

• Description: The Description field provides an explanation of the column. In Power BI, this description will be shown as a tooltip when hovering over the measure.

DisplayFolder

- Table:
    Name: CallStatus
    SourceTable: D_CallStatus
    TableType: Dim
    Columns:
    - SourceColumn: CallGrouping
      Type: varchar(50)
      DisplayFolder: Calls
    - SourceColumn: PhoneStatus
      Type: varchar(50)
    - SourceColumn: IsActive
      Type: bit

• DisplayFolder: The DisplayFolder allows you to organize your measures into folders within Power BI. By organizing measures into folders, you can better structure your tables, making it easier to find specific columns, especially when dealing with large tables.

FormatString

- Table:
    Name: CallStatus
    SourceTable: D_CallStatus
    TableType: Dim
    Columns:
    - SourceColumn: CallGrouping
      Type: varchar(50)
    - SourceColumn: CallOrder
      Type: int
      FormatString: 0
    - SourceColumn: PhoneStatus
      Type: varchar(50)
    - SourceColumn: IsActive
      Type: bit

• FormatString: The FormatString property defines the display format for the column result. In this example, "0" rounds numbers to the nearest integer without decimals.

IsHidden

- Table:
    Name: CallStatus
    SourceTable: D_CallStatus
    TableType: Dim
    Columns:
    - SourceColumn: CallGrouping
      Type: varchar(50)
    - SourceColumn: PhoneStatus
      Type: varchar(50)
    - SourceColumn: IsActive
      Type: bit
      IsHidden: true

• IsHidden: The IsHidden property controls the visibility of the column in Power BI or Excel. Setting it to true hides the measure from the interface. By default, this property is set to false.

IsKey

- Table:
    Name: CallStatus
    SourceTable: D_CallStatus
    TableType: Dim
    Columns:
    - SourceColumn: id
      Type: int
      IsKey: true
    - SourceColumn: CallGrouping
      Type: varchar(50)
    - SourceColumn: PhoneStatus
      Type: varchar(50)
    - SourceColumn: IsActive
      Type: bit

• IsKey: Determines if this column is the primary key of the table. The default setting is false. When set to true, the column is recognized as a primary key.

IsUnique

- Table:
    Name: CallStatus
    SourceTable: D_CallStatus
    TableType: Dim
    Columns:
    - SourceColumn: id
      Type: int
      IsUnique: true
    - SourceColumn: CallGrouping
      Type: varchar(50)
    - SourceColumn: PhoneStatus
      Type: varchar(50)
    - SourceColumn: IsActive
      Type: bit

• IsUnique: Ensures that each entry in the column is unique. The default setting is false. If set to true and duplicate values are found, an error will occur, as this property requires all values to be distinct to maintain data integrity in the model.

OrderByColumn

- Table:
    Name: CallStatus
    SourceTable: D_CallStatus
    TableType: Dim
    Columns:
    - SourceColumn: CallGrouping
      Type: varchar(50)
    - SourceColumn: PhoneStatus
      Type: varchar(50)
      OrderByColumn: Call Grouping
    - SourceColumn: IsActive
      Type: bit
      OrderByColumn: Call Grouping

• OrderByColumn: Identifies the column used for sorting data within the table.