22-25 April 2026

From C# Spells to TMDL Sorcery: Evolving Your Power BI Magic

Proposed session for SQLBits 2026

TL; DR

Step into the evolving world of Power BI model automation, where scripting spells meet the structured sorcery of TMDL. This level 300 session shows how to scale semantic models, reduce repetitive DAX work, and empower teams with a clean, code friendly approach. You’ll learn how to • Automate the creation and maintenance of DAX measures with scripting • Use TMDL to keep model logic readable, reusable, and easier to maintain • Build flexible models that support self service without losing control Grab your wand (or keyboard) and join the journey from scripting spells to semantic sorcery.

Session Details

Step into the evolving world of Power BI model automation, where scripting spells meet the structured sorcery of TMDL. This level 300 session is your next-level guide to empowering teams, scaling solutions, and building flexible, future-proof semantic models with a magical mix of scripting and the new Tabular Model Definition Language.

If you’ve ever felt limited by manual model editing or repetitive DAX creation, this session will show you how to turn those challenges into opportunities. We’ll explore practical ways to generate and organize measures, simplify maintenance, and give report builders more power—without sacrificing structure or sanity.

You’ll learn how to:

- Automate the creation and maintenance of DAX measures using scripting techniques

- Use TMDL to structure your model logic in reusable, readable ways

- Empower report builders through flexible, self-service-ready models

Whether you're the architect building scalable models or the enabler helping others turn data into action, this session will give you the tools to evolve your craft—and your models—with magic, clarity, and purpose.

So grab your wand (or keyboard) and join us on a journey from scripting spells to semantic sorcery.

3 things you'll get out of this session

• Automate the creation and maintenance of DAX measures with scripting • Use TMDL to keep model logic readable, reusable, and easier to maintain • Build flexible models that support self service without losing control