SQLBI Newsletter #312

Don't miss the next newsletter - Subscribe now!

NEW ARTICLE

Analyzing the performance of limited and regular relationships

This article analyzes the performance of regular versus limited relationships in DAX to understand the implications of using limited relationships.
Read more

COURSES IN 2026

2026 DAX classrooms

Mastering DAX classroom courses are now aligned with The Definitive Guide to DAX, Third Edition and as such, they cover new features like DAX User-defined Functions and Calendar-based Time Intelligence.

• North America
Houston, New York City, Baltimore
• Europe
Copenhagen, Zurich, Berlin, Amsterdam

The schedule is final until June; additional classes starting in July, and other continents are under evaluation. Join us in person to learn DAX the right way from the get go, and to boost your productivity: a strong argument when asking your boss for approval!

Read more

COMICS

AI BI Blunders

This comic has been generated by ChatGPT using so many prompts...

#312 · Jan 2026

LEARNING

Course calendar

DATA MODELING - 3 DAYS

	Jul 21-23 - Amsterdam

Mastering DAX - 3 DAYS

	Mar 3-5 - Amsterdam
	Mar 30-Apr 1 - Houston
	Apr 8-10 - New York City
	May 5-7 - Copenhagen
	May 27-29 - Baltimore
	Jun 10-12 - Zürich
	Jun 15-17 - Berlin
	Jun 30-Jul 2 - Amsterdam

video courses

	Introducing DAX
	Mastering DAX
	Optimizing DAX
	Intro to Data Modeling
	Data Modeling for Power BI
	Mastering Tabular
	DAX Tools Video Course
	DAX Patterns
	Power BI Dashboard Design

BI-WEEKLY NEWS DIGEST

Latest news

	• What happened in the DAX world in 2025 You may have missed our end-of-year recap, and our overview of what to expect in 2026. Good, you needed a well-deserved rest! However, you might regret not reading this blog post. In particular, you should watch the video "after" the end: not a real spoiler, just a suggestion! Dec 29, 2025 · Marco Russo
	• Deployment pipelines and Power BI semantic models with Direct Lake on OneLake tables Direct Lake on OneLake is the future, but in the present it is still a work in progress. Take a look a this article if you are going to use it with deployment pipelines. Dec 2, 2025 · Zoe Douglas
	• Diagnosing Power BI DirectQuery connection limit problems with Performance Analyzer DirectQuery over SQL can be slow because of the number of queries sent to the relational database, their execution time, and last but not least the amount of data transferred. You can combine Performance Analyzer and log files to understand where you are paying the biggest price. Of course, if you had used Import mode, now you would have time to watch your favorite movie/sport/series instead of dealing with logs. Dec 28, 2025 · Chris Webb

SQLBI YOUTUBE CHANNEL

Latest videos

What happened in DAX in 2025