Tabular Table

Name	Description
AIInstruction	AI-addressed instruction for the table. Surfaced in the wiki graph and never emitted to Power BI / Excel. When set it overrides Description as the graph instruction value
DataCategory	Classification of the table
Description	Description of the table
IsGenerated	Is the table included in the model (default=true)
IsHidden	Is the table hidden in the model (default=false)
Loadsettings	The notebook(s) that produce the gold table for this table, and the order they run
Name*	Name of the table in the tabular model
PermittedRoles	Roles that have permission to use this table
ProcessLoadOrder	Order group for the tabular refresh: `DAG_Tabular` refreshes tables per ascending ProcessLoadOrder group (default=0)
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. A leading underscore (a common convention for system tables) is kept in the model but stripped from every generated physical name: Name: _Klant yields gold table d_klant (physical gold table names are generated in lowercase) and key columns SK_Klant, BK_Klant — never a double underscore.
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 — one of Fact, Dim, Help, or CalculationGroup (case-insensitive; any other value fails generation). A calculation group is declared with TableType: CalculationGroup; a standalone helper table with TableType: Help (see Help Table below).
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

Help Table

- Table:
  Name: TestAudit
  SourceSchema: dbo
  SourceTable: h_testaudit
  TableType: Help
  Columns:
  - SourceColumn: Melding
    Type: varchar(1024)
    IsKey: true
  - SourceColumn: Sleutelwaarde
    Type: varchar(255)
  - SourceColumn: Aantal
    Type: int

A Help table is a standalone helper table that you define completely yourself:

No generated keys: no surrogate key or business key columns are added — the columns you list are exactly what the table gets (plus the framework's source-tag audit column in the physical gold table). You can still mark one of your own columns with IsKey: true (or IsUnique: true): this flows into the semantic model, where uniqueness is enforced at refresh time. The physical lakehouse table has no constraint — keeping the data unique is up to the load.
No relationships: a Help table cannot declare References, and other tables cannot reference it. Generation fails with a clear error if either is attempted.
Naming: the physical gold table follows the same prefix convention as Dim and Fact: HelpObjectPrefix (default H) plus Name with spaces converted to underscores, generated in lowercase like every physical gold table — here h_testaudit. As with Dim/Fact, set SourceTable to that physical name so the gold loader targets the generated table, and a leading underscore in Name is stripped before the prefix is applied (Name: _testAudit → gold table h_testaudit, model table _testAudit). Setting HelpObjectPrefix to an empty string drops the prefix entirely: the gold table is then named after Name, including a leading underscore.
Still a real table: like Dim and Fact it requires a SourceTable (or Partitions) and at least one column, and its gold table is generated and loaded like any other.

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.

Basic Table​

Help Table​

Advanced Table​

Basic Table

Help Table

Advanced Table