22-25 April 2026

Advanced Semantic Model development with Tabular Editor

Proposed session for SQLBits 2026

TL; DR

Join us for a full-day workshop to learn everything there is to know about the Tabular Object Model - the metadata structure behind the beloved semantic models in Power BI, and learn how Tabular Editor 2 can help in every aspect of model development.

Session Details

Power BI Desktop is a great tool for learning the basics of Semantic Model development. However, if you really want to get your hands dirty and unlock the full potential of Semantic Models in Power BI and Fabric, you’ll need a tool that goes beyond the surface. That tool is Tabular Editor.

In this full-day workshop, we’re going to take the gloves off and dive deep into the Tabular Object Model (TOM), to gain a complete understanding of the metadata structure behind every Analysis Services Tabular Model and Power BI / Fabric Semantic Model. We’re going to explore objects and properties that you might not even know existed! Tabular Editor (free or paid version) is our tool of choice in this endeavour, as the tool gives us full, unlimited and unfiltered access to the TOM tree behind the model. Moreover, Tabular Editor lets us interact with the TOM programmatically through C# scripts – a super powerful feature, when you’re looking to automate certain operations or workflows on your Semantic Models.

Join this workshop if you’re curious about taking your Semantic Model development skills to the next step.

Topics covered:
- Introduction to AMO and TOM
- TOM exploration using Tabular Editor and C# scripts
- TOM exploration using PowerShell and other tools
- Understanding TMSL (Tabular Model Scripting Language) and TMDL (Tabular Model Definition Language)
- Advanced TOM objects and properties
- Best Practice Analyzer and custom rules
- Automation with the Tabular Editor CLI
- Use cases and scenarios

3 things you'll get out of this session

At the end of this training day, attendees will have gained the following: - A solid understanding of the Tabular Object Model (TOM), and advanced objects/properties within it. - Practical skills on how to work with the TOM, using Tabular Editor, C#, PowerShell and other techniques. - Tips and tricks that make you more productive when developing Semantic Models - Knowledge about automation, enabling advanced management scenarios for DevOps and Deployment