Tabular Table

Name	Description
DataCategory	Classification of the table
Description	Description of the table
IsGenerated	Is the table included in the model (default=false)
IsHidden	Is the table hidden in the model (default=false)
Name*	Name of the table in the tabular model
PermittedRoles	Roles that have permission to use this table
ProhibitedRoles	Roles that are not allowed to use this table
SourceSchema	Schema of the table in the source database
SourceTable	Name of the table in the source database
TableType	Type of the table in the model
References	Relations to other tables in the model

* Indicates that the field is mandatory.

Basic Table

- Table:
  Name: Invoices
  SourceSchema: dm
  SourceTable: F_Invoices
  TableType: Dim
  Description: "Fact: Invoices"
  IsHidden: false
  References:
    - Table: Date
    - Table: Employee
    - Table: Question
  Columns:
  - SourceColumn: Date
    Type: date
  - SourceColumn: Patient
    Type: int
  - SourceColumn: Answer
    Type: varchar(255)

• Name: The table’s unique name in the tabular model.
• SourceSchema: Name of the schema in the source database where the table is located.
• SourceTable: Name of the actual table in the source database.
• TableType: Defines the type of table in the model (e.g., Dimension or Fact).
• Description: The Description field provides an explanation of the table. In Power BI, this description will be shown as a tooltip when hovering over the table. If no description is provided, a default label will be shown, such as "Fact: [TableName]" or "Dimension: [TableName]," based on the table type.
• IsHidden: The IsHidden property controls the visibility of the measure in Power BI or Excel. Setting it to true hides the measure from the interface. By default, this property is set to false.
• References: Specifies relationships with other tables in the model. The References are explained in detail on this page: Tabular reference
• Columns: 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. The Columns are explained in detail on this page: Tabular column

Advanced Table

- Table:
  Name: Invoices
  SourceSchema: dm
  SourceTable: F_Invoices
  TableType: Dim
  Description: "Fact: Invoices"
  IsHidden: false
  IsSourceView: True
  DataCategory: Time
  KeyDataType: int
  IsGenerated: true
  PermittedRoles: [Admin, Analyst]
  ProhibitedRoles: [Guest]
  References:
    - Table: Date
    - Table: Employee
    - Table: Question
  Columns:
  - SourceColumn: Date
    Type: date
  - SourceColumn: Patient
    Type: int
  - SourceColumn: Answer
    Type: varchar(255)

• IsSourceView: Indicates whether the table is a view derived from the source database. When set to true, it means that the table is not a direct representation of a physical table but a view.
• DataCategory: Classification of the table for analytical or reporting purposes.
• KeyDataType: Specifies the data type used for the key in the table, typically int, which uniquely identifies records within the table.
• IsGenerated: Indicates if the table is automatically generated in the model (true or false).
• PermittedRoles: List of user roles that are allowed access to this table.
• ProhibitedRoles: List of user roles that are restricted from accessing this table.