TMSL Reference - Commands overview
Applies to: SQL Server 2016 and later Analysis Services Azure Analysis Services Fabric/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. |