22-25 April 2026 
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
Ana Maria Bisbe York's previous sessions
Let's define Entities and attributes for tabular models in 20 minutes.
Examples from real-life projects that demonstrate the issue and improve the design of entities for the tabular models.
Lets play with a date field & Time Intelligence in Power BI
Date fields play an important role in virtually all cases of advanced analytics. The "problem & solution" style session can be very useful given the large number and variety of scenarios that may arise
Lets do the cleansing with M and / or Python languages
This short session will cover some scenarios of cleansing data in Power Query using M, Python, or both languages.
Some transformations that can save your ETL in Power BI
To build analytical models, we need to start by extracting, transforming, cleaning, preparing and loading the data. This session analyzes a set of scenarios that may happen during the ETL step using the Power Query in Power BI.