SQLBI Newsletter #293

NEW ARTICLE

This article describes how to implement a dynamic Pareto calculation in Power BI based on a measure that can be selected from a slicer and dynamically filtered by other slicers in the report.
Read more

SQLBI REPLAY

Using join functions in DAX

This article describes the practical uses of NATURALLEFTOUTERJOIN and NATURALINNERJOIN in DAX. These functions are not commonly used in DAX because they do not have the same flexibility as the corresponding concepts in SQL.
Read more

#293 · Apr 2025

LEARNING

Course calendar

Mastering DAX - 3 DAYS

	May 20-22 - Amsterdam
	May 28-30 - Chicago
	Jul 9-11 - Seattle
	Aug 19-21 - Toronto

DATA MODELING - 3 DAYS

	Jun 24-26 - 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

CLASSROOM COURSES

Registrations open for Seattle and Chicago

Marco is coming to the US for Mastering DAX classroom courses in May and July!

Hurry and book your seat before the courses sell out!

BI-WEEKLY NEWS DIGEST

Latest news

	• Monitoring for Power BI admins All the options to monitor your Power BI tenant: Fabric Capacity Metrics App, Fabric Feature Usage and Adoption Report, and Fabric Unified Admin Monitoring are ready to use for Fabric users, but you have options also with Power BI without Fabric: Log Analytics and Scanner APIs. A good read if you need clarity about this topic. Mar 5, 2025 · Jake Duddy
	• Creating DAX from Fabric Data Agents You can generate DAX with several LLM tools, two of them in Fabric: Copilot for Power BI and the less popular Fabric Data Agents, formerly known as AI Skills. Correctness is not guarantee, but it is interesting to see the evolution in progress. However, creating a good semantic model is still your best investment. Apr 6, 2025 · Chris Webb
	• Keep history of usage metrics in Power BI How to overcome the 30 days history limit of Power BI usage metrics by ingesting the result of DAX queries in Spark. The same approach could be used to copy data to another storage without using Fabric. Apr 15, 2025 · Ben Fedit
	• Using notebooks to health-check your semantic models Microsoft introduced a section of the ribbon in Power BI service model view that directly opens Fabric notebooks to run Best Practices Analyzer (BPA) and Memory Analyzer (subset of features of VertiPaq Analyzer) directly on the published semantic models. Easy to use, at the cost of some Consumption Units on your tenant. Apr 1, 2025 · Microsoft

SQLBI YOUTUBE CHANNEL