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. |
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for