Tabular Editor 2 is a Windows development tool for creating and maintaining semantic data models in Power BI, SQL Server Analysis Services, and Azure Analysis Services. It allows users to modify measures, calculated columns, display folders, perspectives, and translations through a hierarchical model explorer. Its interface supports editing model metadata without loading underlying data. Advanced C# scripting automates repetitive modeling tasks and bulk changes. A built-in Best Practice Analyzer helps identify modeling issues and enforce development standards. Users can edit DAX expressions and manage relationships, hierarchies, and calculation groups. Command-line capabilities support automated deployment and validation workflows. The application works with tabular models at compatibility level 1200 and higher.
Features
- Hierarchical semantic model editing for Power BI and Analysis Services
- Bulk management of DAX measures, calculated columns, and display folders
- Advanced C# scripting for automating repetitive model development tasks
- Best Practice Analyzer with configurable modeling rules and validation checks
- Calculation group, hierarchy, perspective, and translation management
- Command-line model deployment, automated validation, and CI/CD integration