SQLBI Newsletter #318

Don't miss the next newsletter - Subscribe now!

NEW ARTICLE

Using visual calculations to highlight an entire row

Visual calculations are a good tool to format visuals: this example shows how to highlight a matrix row based on the value in the last column.
Read more

NEW BLOG POST

Unplugged conversation about the new Mastering DAX

Alberto and Marco recorded an unplugged video to talk about the third edition of the Mastering DAX Video Course.
Read more

COMICS

AI BI Blunders

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

#318 · Apr 2026

LEARNING

Course calendar

DATA MODELING - 3 DAYS

	Jul 21-23 - Amsterdam

Mastering DAX - 3 DAYS

	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

Stop guessing DAX. Start mastering it with Mastering DAX Video Course 3rd Edition.

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

See beyond the charts - Synoptic Panel for Power BI by OKVIZ

BI-WEEKLY NEWS DIGEST

Latest news

	• New content on SQLBI+: How to navigate the lattice of visual calculations There is a new video for SQLBI+ subscribers that explains how to navigate the lattice of visual calculations in DAX, using COLLAPSEALL and EXPAND to move between levels. A key topic is the difference between ROWS/COLUMNS and VALUES of ROWS/COLUMNS. The video also shows how to create reusable visual calculation functions that encapsulate lattice navigation logic, simplifying otherwise complex code. Apr 6, 2026 · SQLBI
	• Dataflows Gen1 declared legacy Microsoft officially declared Dataflows Gen 1 legacy, so we can expect it to be retired in the future. Unfortunately, the announcement does not clarify what the future holds for companies without the Fabric capacity required for Gen2. After a few hours, only negative comments remain below the announcement. This can become a trust issue rather than a feature issue if Microsoft does not react quickly. Apr 2, 2026 · Microsoft
	• How Tabular Editor supports agentic development for semantic models Tabular Editor 3 supports agentic development with the "bring your own model" approach. The big difference between this approach and others is that the tool modifies the semantic model by creating C# scripts, which simplify the detection of inconsistencies. Moreover, a new CLI tool will support other agentic uses. It looks promising. Mar 26, 2026 · Kurt Buhler
	• Optimizing semantic model refresh memory in Power BI If your model takes too long to refresh or fails to do so because of a memory issue, you need to optimize the refresh process. Because there is so much you can do before adding more memory or increasing the capacity level. Mar 24, 2026 · Just Blindbæk

SQLBI YOUTUBE CHANNEL

Latest videos

DAX User-Defined Functions vs Calculation Groups