How-tos

This section contains step-by-step guides for accomplishing specific tasks with Tabular Editor.

In this section

Scripting and Automation

• Advanced Scripting - C# scripting for model manipulation and automation
• Script Reference Objects - Working with object references in scripts

Model Management and Deployment

• Deployment - Deploy models to Analysis Services databases
• Connect to SSAS - Connect to and work with SSAS Tabular databases
• Load and Save - Loading and saving model files
• Folder Serialization - Save models as folder structures for version control
• Master Model Pattern - Managing multiple models with perspectives

Data Import and Tables

• Importing Tables - Import tables from various data sources
• Importing Tables from Excel - Excel-specific import procedures
• Replace Tables - Replace existing tables with new data sources

Model Organization and Structure

• Advanced Filtering of Explorer Tree - Filter and organize model objects
• Drag and Drop - Using drag and drop functionality
• Duplicate and Batch Rename - Efficiently manage object names
• Edit Properties - Modify object properties

Translations and Perspectives

• Import/Export Translations - Manage multi-language support
• Perspectives and Translations - Working with model perspectives

Data Security and Roles

• Roles and Row-Level Security - Implement data security with RLS

Connectivity and Integration

• XMLA Analysis Services Connectivity - Connect via XMLA endpoints
• Power BI XMLA PBIX Workaround - Work with Power BI through XMLA

Model Maintenance

• Formula Fixup Dependencies - Automatically fix formula references
• Metadata Backup - Backup and restore model metadata
• Undo and Redo - Using undo/redo functionality

Semantic Bridge

• Load and Inspect a Metric View - Load a Metric View and explore its structure
• Import a Metric View and View Diagnostics - Import a Metric View to Tabular and view diagnostics
• Validate a Metric View with Default Rules - Validate with built-in rules
• Create Simple Validation Rules - Create predicate-based validation rules
• Create Contextual Validation Rules - Create rules with cross-object checks
• Add an Object to a Metric View - Add a new object to a Metric View
• Remove an Object from a Metric View - Remove objects from a Metric View
• Rename Objects in a Metric View - Rename objects using copy-modify pattern
• Serialize a Metric View to YAML - Serialize a Metric View back to YAML

---

Navigate using the table of contents to find guides for specific tasks.