22-25 April 2026

TMDL in Action: Optimizing Power BI Models with Advanced Scripting

Proposed session for SQLBits 2026

TL; DR

This session focus on TMDL scripting in Power BI. Learn how you can customize your data models, fine-tune refresh, implement complex DAX calculations, and reuse code beyond the standard UI. Focus on bulk updates, performance optimization, and code-based model management.

Session Details

This presentation explores the power of Tabular Model Definition Language (TMDL) for defining and managing tabular models in Power BI. MDL enables developers to create, update, and optimize data models with precision and control.

This session highlights key TMDL features, such as creating tables, measures, and relationships, and demonstrates practical applications for enhancing data modeling efficiency and scalability in Power BI.

The session includes a hands-on approach, covering:

Navigating the TMDL View in Power BI Desktop to script, modify, and validate model definitions.

Creating and editing tabular models using TMDL, including defining tables, measures, and relationships.
Usage of MCP to boost your TMDL experience, and make changes in a faster and more efficient manner.

Best practices for maintaining large-scale models with scalability and performance in mind.

Participants will leave the session equipped with practical skills to integrate TMDL into their Power BI workflows, leveraging both Developer Mode and the TMDL View to streamline development and improve data modeling efficiency.

3 things you'll get out of this session

Participants will leave the session equipped with: * Practical skills to integrate TMDL into their Power BI workflows, * Leveraging TMDL View to streamline development * Improve data modeling efficiency using MCP and TMDL

Speakers