TMDL in Action: Optimizing Power BI Models with Advanced Scripting
Proposed session for SQLBits 2026TL; 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.
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
Pragati Jain's other proposed sessions for 2026
Break the Read-Only Barrier: Real-Time Action with Fabric Translytical Flows - 2026
Fabric in Flux: Streamlining Development with Azure DevOps & Git - 2026
Notebooks Unbound: Trigger, Parameterize, and Schedule Like a Pro - 2026
See It, Fix It, Optimize It: Monitoring That Works in Microsoft Fabric - 2026
The Fabric Access Puzzle: Cracking Permission Problems with Confidence - 2026
Miguel Félix
pbiportugal.com
Miguel Félix's other proposed sessions for 2026
Excel Lives! Your Gateway to Microsoft Fabric - 2026
Click minimalism in Power BI development - 2026