TMSL Reference - Commands overview
Applies to:
SQL Server 2016 and later Analysis Services
Azure Analysis Services
Power BI Premium
You can execute commands on an XMLA endpoint, formulating object definitions in JSON using the Tabular Model Scripting Language (TMSL), against tabular model databases. See TMSL Reference - Objects overview for a list of objects used with the following commands.
Object operations
Command | Description |
---|---|
Alter command (TMSL) | Make inline modifications to an object without having to specify the full definition. |
Create command (TMSL) | Creates a new object, including its descendants. |
CreateOrReplace command (TMSL) | Create or replace parts of an object definition. The full definition must be provided. |
Delete command (TMSL) | Delete an object, including its descendants. |
Data refresh operations
Command | Description |
---|---|
MergePartitions command (TMSL) | Merge a target partition into a source, and delete the target. |
Refresh command (TMSL) | Process a database, table, or partition. |
Scripting
Command | Description |
---|---|
Sequence command (TMSL) | Batch operations sequentially or in parallel |
Database management operations
Command | Description |
---|---|
Attach command (TMSL) | Adds a file to the server. |
Detach command (TMSL) | Removes a file from the servers. |
Backup command (TMSL) | Creates a backup file of a database. |
Restore command (TMSL) | Restores database to the server. |
Synchronize command (TMSL) | Synchronizes a tabular database with another existing database. |