SQLBI Newsletter #299

NEW ARTICLE

ALLSELECTED is a powerful, yet dangerous function. This article describes the best practices to follow to avoid falling into the pitfalls involved with ALLSELECTED.
Read more

OKVIZ VISUAL

Introducing Synoptic Panel v2

Synoptic Panel v2 by OKVIZ (our sister company) is a new version of the custom visual for Power BI that can transform any SVG image into a dynamic data visualization with maps, floorplans, diagrams, and more. After more than a year of beta testing and a silent general availability release a few months ago, it is now ready to take center stage!
Read more

#299 · Jul 2025

LEARNING

Course calendar

DATA MODELING - 3 DAYS

	Dec 2-4 - Amsterdam

Mastering DAX - 3 DAYS

	Aug 19-21 - Toronto
	Oct 1-3 - London
	Oct 28-30 - Lugano
	Nov 4-6 - Amsterdam
	Nov 12-14 - Chicago
	Dec 8-10 - Austin

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

CLASSROOM COURSES

Mastering DAX in Toronto

Do not miss our next classroom course in Toronto with Alberto Ferrari!

This will be our only course in Canada in 2025.

Come join Alberto before seats run out!

Aug 19-21, 2025 - Toronto, CA

BI-WEEKLY NEWS DIGEST

Latest news

	• Translytical Sudoku While we await significant news around Power BI, an interesting article about the new "Translytical Task Flows" for Power BI shows how to create a Sudoku game in Fabric with Power BI, using Fabric UDFs, stored procedures, Fabric SQL Server, and of course Power BI. These articles are good catalysts for new ideas. Jul 10, 2025 · Jake Duddy
	• Creating a Power BI Knowledge base with NotebookLM Need help finding the right info in Power BI documentation? You can organize a Power BI knowledge base using an LLM! Jun 26, 2025 · Mihaly Kavasi

SQLBI YOUTUBE CHANNEL

Latest videos

Choosing between DISTINCT and VALUES in DAX