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.