SQLBI Newsletter #315

Don't miss the next newsletter - Subscribe now!

NEW ARTICLE

Debugging DAX variables using TOJSON and TOCSV

This article describes how to use the TOJSON and TOCSV functions to inspect the content of intermediate table variables when debugging a DAX measure.
Read more

COMICS

AI BI Blunders

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

COURSES IN 2026

2026 DAX classrooms

Book your seat to the new edition of our Mastering DAX classroom course: we still have a few last-minute seats in Amsterdam!

This third edition is aligned with the third edition of the Definitive Guide to DAX, as well as the third edition of the Mastering DAX video course.

The schedule is final until June; don't miss the upcoming, confirmed classes in Houston and New York City. Register early to secure your seat.

Read more

#315 · Feb 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

	• New books about DAX Are we putting ourselves in a blatant conflict of interest by mentioning a blog post that reviews our latest book? Yes, we are! However, you can judge us only 50% of the way through the blog post, because there is also a review of a book about visual calculations. Yeah, that's a lot of DAX. And yes, it is a nice review! Feb 15, 2026 · Chris Webb
	• Table interceptors in Power Query Did you know that you can intercept an operation over a table and redirect it? For example... you can manage the count rows of a table without... counting the rows of the table! This is just an example, in reality the flexibility provided by Table.View in M is extensive. Feb 5, 2026 · Ben Gribaudo
	• Deprecation of old Excel and CSV import experience in Power BI Service Using "deprecation" and "Excel" in the same sentence may seem like clickbait. It is not, it should affect a relatively small number of users, but those who are affected will not like it. May 31, 2026 is the first deadline approaching. Take a look at it if you had imported Excel/CSV files years ago, and then had forgotten about it because it just worked. Feb 10, 2026 · Microsoft
	• Deep dive into composite semantic models with Direct Lake and import tables Mixing Direct Lake and Import mode tables in the same model has technically been possible for months, but the official tools are late in offering a seamless experience. The situation is improving, but it's still not ideal. This is a good recap of current "how-tos". Feb 2, 2026 · Microsoft

SQLBI YOUTUBE CHANNEL