Advanced Semantic Model development with Tabular Editor
Proposed session for SQLBits 2026TL; 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
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
Speakers
Just Blindbæk's other proposed sessions for 2026
Building a Unified Semantic Model - The 20-Minute Pattern - 2026
Choosing the Right Storage Mode: Import, Direct Lake, DirectQuery & Hybrid - 2026
Deep Dive: Mastering Semantic Model Size & Refresh Efficiency in Fabric Capacities - 2026
Deep Dive: Mastering Semantic Model Size & Refresh Efficiency in Fabric Capacities - 2026
Demystifying the Data Lakehouse in Microsoft Fabric - 2026
Mastering Spark Notebooks and Capacity Optimization in Microsoft Fabric - 2026
Unified Semantic Models & KPI Reporting: Architecture That Scales - 2026
Panel Debate: Real-World Microsoft Fabric Administration - Lessons from the Trenches - 2026
Just Blindbæk's previous sessions
Mastering Fabric: Workspace Governance and Organization
Learn how to optimize and master workspace organization in Fabric. Explore best practices for effective governance, enhancing user experience, security, and permissions management. Gain practical insights and checklists for streamlined workspace management.
The Hitchhiker's Guide to navigating Power BI
Learn to navigate Power BI seamlessly in this concise session. Explore key areas: Internal Report navigation, App transitions, and Web Portal optimization. Elevate user experience with insights on service navigation, integration, and essential tools like Drill Through, Buttons, and Bookmarks.