Querying data and metadata with T-SQL, M and DAX
Proposed session for SQLBits 2026TL; DR
Let's have fun, HappyQuerying data using T-SQL, M, and DAX.
Session Details
Measuring the effectiveness of the semantic model and queries is one way to identify performance issues and potential improvements.
This session is for individuals who need to understand the model's composition and improve it. The session is intended for users who query data, particularly semantic models using DAX.
This is my day-to-day, and this is my interest in sharing with the audience.
We will shortly review query data stored in a relational database and develop examples using T-SQL, M, and DAX in their respective environments: SQL Server Management Studio, Power Query, the DAX Query View in Power BI, and DAX Studio.
We will examine the DAX query structure and learn how to work with filters, groupings, aggregations, and combinations.
This session is for individuals who need to understand the model's composition and improve it. The session is intended for users who query data, particularly semantic models using DAX.
This is my day-to-day, and this is my interest in sharing with the audience.
We will shortly review query data stored in a relational database and develop examples using T-SQL, M, and DAX in their respective environments: SQL Server Management Studio, Power Query, the DAX Query View in Power BI, and DAX Studio.
We will examine the DAX query structure and learn how to work with filters, groupings, aggregations, and combinations.
3 things you'll get out of this session
Have fun querying data.
Look at the efficiency of the data and metadata queries.
Understand the composition and quality of the semantic model.
Speakers
Ana Maria Bisbe York's other proposed sessions for 2026
SQL Fabric, the perfect combination of experience and youth - 2026
To filter or not to filter, that is a question - 2026