Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
TMDL scripts
TMDL scripts enable you to apply an action to a semantic model, which could be a change or operation. A TMDL script has two parts:
- A command, which is required and should be declared at the top of the TMDL script.
- One or more semantic model objects using TMDL language definition or reference.
Syntax:
<TMDL Command name>
<TMDL object>
[<TMDL object>]
CreateOrReplace command
Creates or replaces the specified semantic model objects and all the descendants. Existing objects are replaced with a new definition.
The order of TMDL objects inside the createOrReplace command is not important.
The semantics of TMDL language are applied to objects within the createOrReplace command. For example, it's possible to split the object definition into multiple segments, however the same property can't be declared more than once. You can learn more about the TMDL language.
Example
Create or replace the measure # Products (with Sales) from the table Sales and the full definition of the table Product:
createOrReplace
ref table Sales
measure '# Products (with Sales)' = DISTINCTCOUNT('Sales'[ProductKey])
formatString: #,##0
table Product
measure '# Products' = COUNTROWS('Product')
formatString: #,##0
column Product
dataType: string
isDefaultLabel
summarizeBy: none
sourceColumn: Product
column Category
dataType: string
summarizeBy: none
sourceColumn: Category
partition Product-partition = m
mode: import
source =
let
Source = #"RAW-Product",
#"Renamed Columns" = Table.RenameColumns(Source,{{"Product Name", "Product"}})
in
#"Renamed Columns"
Considerations and limitations
Only one command verb per script execution is supported.
Related content
The following articles describe more about TMDL and its uses.
Feedback
Was this page helpful?