SQLBI Newsletter #326

Don't miss the next newsletter - Subscribe now!

NEW ARTICLE

Analyzing the performance impact of visual calculations

Visual calculations can either improve or degrade the performance of a report. In this article, we outline how we ensure visual calculations have a positive impact on performance.
Read more

COMICS

AI BI Blunders

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

CLASSROOM COURSES IN 2026

Attend the new in-person Mastering DAX

Hurry, we are only offering five in-person DAX classroom courses until the end of 2026:

North America & United Kingdom

Europe

We continue to update our in-person training with the latest news, new exercises, and full access to the video course as soon as your seat is confirmed!

#326 · Jul 2026

LEARNING

Course calendar

DATA MODELING - 3 DAYS

Mastering DAX - 3 DAYS

	Oct 12-14 - Warsaw
	Oct 27-29 - Lugano
	Nov 9-11 - Atlanta
	Nov 24-26 - London
	Dec 1-3 - 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

	• OKVIZ Index: A better way to find Power BI visuals Have you tried searching for a custom visual on AppSource? OKVIZ Index is a better catalog of custom visuals for Power BI, allowing you to compare items with a broader context than what AppSource offers. Plus, it's much faster and compatible with AI assistants! Give it a try. Jul 22, 2026 · OKVIZ
	• Power BI July 2026 updates While there is a new parameter for the LOOKUP function for visual calculations in DAX, there are no major news for reporting and modeling. However, the clear path is that the web modeling experience is reducing the gap with Power BI Desktop. Jul 22, 2026 · Microsoft
	• The benefits of using Direct Lake mode in Power BI Direct Lake is a tool. As such, it should be used when it is helpful, and not when its benefits do not compensate for its (current) limitations. It is a work in progress, not a finished tool. You must read the many comments on this article to get the full picture. Jul 12, 2026 · Chris Webb
	• How Anthropic enables self-service data analytics with Claude This is an almost two-month-old article, which we missed when it came out. Zero news. One Big Table (OBT) is a non-starter. Querying raw normalized tables is no better. Still, our readers now have a non-Microsoft link that repeats what data practitioners have been saying for three decades, if only to shut down yet another boring conversation. Jun 3, 2026 · Anthropic

SQLBI YOUTUBE CHANNEL

Latest videos

Dynamic formatting by hierarchy level with ISINSCOPE and ISATLEVEL