SQLBI Newsletter #256

NEW ARTICLE

Computing accurate percentages with row-level security in Power BI

This article shows how to compute ratios when row-level security hides some of the data. If the percentage also includes the hidden rows in the comparison, you should customize the data model and the measures involved to get the right result.
Read more

NEW BLOG POST

DirectQuery modules in the Optimizing DAX video course

The DirectQuery over SQL section of Optimizing DAX is now available!

The new section adds more than 5 hours to the existing 29 hours of videos.

#256 · Nov 2023

LEARNING

Course calendar

Mastering DAX

	Dec 5-7 - Cologne
	Feb 27-29 - Dallas
	Mar 4-6 - Amsterdam
	Apr 15-17 - New York City
	May 22-24 - Copenhagen
	Jun 25-27 - Chicago

Data Modeling

	Jul 2-4 - Amsterdam

video courses

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

NEW ARTICLE

Analyzing calculation groups with DAX Optimizer

This article explains how to evaluate the performance of calculation groups in DAX Optimizer by creating corresponding measures that produce an equivalent query plan.

BI-WEEKLY NEWS DIGEST

Latest news

	• Black Friday is coming Get ready for our once-in-a-year Black Friday Sale on all our video products and subscriptions. OK, once a year we have commercial news... Now, back to the regular programming! Nov 21, 2023 · SQLBI
	• Power BI November 2023 updates Thanks to the release of Microsoft Fabric, the November update of Power BI includes many new features in preview. The big news here is the DAX Query View, which brings into Power BI Desktop the main feature of DAX Studio: write a DAX query and execute it. Don't miss our latest Unplugged video about DAX Query View! Nov 15, 2023 · Microsoft
	• Datasets renamed to semantic models Do you remember "dataset" in Power BI? It is now called "semantic model". This name change makes a lot of sense, it better represents what a Tabular model is, and we at SQLBI are happy with a name change made by Microsoft. It does not happen often, so enjoy the moment! Nov 10, 2023 · Microsoft
	• Semantic models in simple terms If you wonder why "semantic model" is a good rename, or if you need a good description of what a good semantic model is, here is a clear explanation. Nov 17, 2023 · Kurt Buhler
	• Excel workbook layout and the performance of reading data with Power Query in Power BI Reading a small table that is part of a large Excel file could be very slow. You can understand why by reading this insightful article, or split your small table into a small file and never deal with this issue. Nov 12, 2023 · Chris Webb
	• Microsoft Fabric is generally available We know, it's unlikely you haven't heard about the Microsoft Fabric announcement. We suggest you look at the many announcements made in the last week. We keep the focus on DAX and data modeling for our newsletter, but you cannot afford to ignore Fabric anymore. Nov 15, 2023 · Microsoft
	• Tabular Editor 2.21.0 release The latest version of Tabular Editor 2 supports models with DirectLake and the latest TMDL, plus many more bug fixes and other improvements. Nov 12, 2023 · Daniel Otykier

SQLBI YOUTUBE CHANNEL