SQLBI Newsletter #295

NEW ARTICLE

Understanding the error in Power BI, can't determine relationship between the fields

This article explains why you might encounter a curious error when placing columns from unrelated tables in a Power BI matrix.
Read more

NEW FREE SESSION

Choosing Between Import Mode, Direct Lake, and Composite Models

This 90-minute video shows a new semantic model feature, "Direct Lake + Import", now in preview , which helps choose between Direct Lake and Import mode in Fabric. The blog post contains a recap of the video, but we strongly suggest you watch the entire session!
Read more

#295 · May 2025

LEARNING

Course calendar

Mastering DAX - 3 DAYS

	May 28-30 - Chicago
	Jul 9-11 - Seattle
	Aug 19-21 - Toronto
	Oct 1-3 - London
	Nov 4-6 - Amsterdam
	Nov 12-14 - Chicago

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

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI datamart will be removed on October 1, 2025 Yes, there is Fabric and you should move your datamart there. We have all predicted that with Fabric. Now it is official and there is a deadline. Our comment: Power BI per User licenses have no good alternatives for their license. If you are impacted, vote for having a "per-user license to get Fabric Capacity". Apr 7, 2025 · Microsoft
	• LLMs and DAX: Where things stand today Results of the internal studies made by the Power BI development team on the DAX code generated by different LLMs. Long story short: you need a good semantic model. No free lunch. May 14, 2025 · Jeffrey Wang
	• Deep dive into selection expressions for calculation groups There are new features to control multiple selection and no selection in calculation groups. We are going to cover that in the next newsletter with article and video, but you can start from the blog post on the Microsoft website. Apr 15, 2025 · Microsoft
	• Write a DAX Query output to a Lakehouse table using a Fabric notebook We will always promote a blog post showing how to consume the results of DAX queries! After all, we have a whole whitepaper about writing DAX queries! May 14, 2025 · Gilbert Quevauvilliers
	• Documenting Power BI semantic models with Fabric Data Agents We like LLMs as they can do the boring work for us. The only question is, who will read the documentation? Nobody reads documentation - besides other LLMs, perhaps! May 4, 2025 · Chris Webb

SQLBI YOUTUBE CHANNEL