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
Pragati Jain's previous sessions
Miguel Félix
pbiportugal.com
Miguel Félix's other proposed sessions for 2026
Excel Lives! Your Gateway to Microsoft Fabric - 2026
Miguel Félix's previous sessions
Prepare for Takeoff: Navigating Power BI Developer Mode - Is the Journey Worth the Flight?
The new Power BI Developer Mode changes dataset and report development, providing a faster, more accessible approach. This mode includes source control and seamless integration with DevOps and Fabric, making it an impressive tool for advanced users and IT professionals.
However, the good news is that you don't need to be a full-time developer or have an extensive IT background to benefit from this feature. In this session, I will demonstrate how you can take advantage of Developer Mode without the need for advanced integrations like DevOps and Fabric.
Combine Power BI with External Tools
In this session we will take a look into some external tools and how can they help us take the our development skills to another level.
From the creation of metrics to the deployment of models the usage of Power BI can be optimize using external tools.
This session is for intermediate users that already know their way into Power BI but want to increase their development skills and speed.