SQLBI Newsletter #271

NEW ARTICLE

Filter context in DAX explained visually

This article describes the DAX filter context using a conceptual model based on a visual representation.
Read more

#271 · Jun 2024

LEARNING

Course calendar

Mastering DAX - 3 DAYS

	Jun 25-27 - Chicago
	Aug 6-8 - Melbourne
	Aug 12-14 - Sydney
	Aug 19-21 - Brisbane
	Sep 18-20 - Calgary
	Oct 14-16 - London
	Nov 19-21 - Amsterdam
	Dec 2-4 - Copenhagen

DAX OPTIMIZATION - 1 DAY

	Aug 9 - Melbourne
	Aug 15 - Sydney

DATA MODELING - 3 DAYS

	Jul 2-4 - Amsterdam
	Sep 23-25 - Vancouver
	Dec 10-12 - 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 COURSES

Mastering DAX in London, UK

Marco will be back in London in October 2024!

London, UK - October 14-16: Mastering DAX

Reserve your seat now: This is the only course in the UK for 2024!
Overall schedule

Mastering DAX in London, UK - October 2024

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI June 2024 udpate The biggest news of this update for our subscribers is probably the ability to download large semantic models! Understandably, models with incremental refresh are not supported. There are also limitations on size, with 50GB as hard limit. However, this feature is very welcome! Jun 12, 2024 · Microsoft
	• Power BI enhanced report format (PBIR) This is very technical news, but it is very important for team development of reports. There is a new format of reports that enables a better integration with source control and collaborative development. It is in preview, it has several limitations, but it is important to understand future directions. Jun 13, 2024 · Microsoft
	• Power BI semantic model memory errors: command memory limit If you use XMLA commands to modify and refresh a model, you want to know memory restrictions you can deal with. Jun 2, 2024 · Chris Webb
	• Formatting DAX measures using semantic link in Fabric If it is not formatted, it is not DAX. If you create semantic models on the Power BI service and you cannot use external tools like Bravo for Power BI or Tabular Editor, you can still use DAX Formatter from a notebook in Fabric! Jun 14, 2024 · Sandeep Pawar
	• Improve Power BI Copilot with linguistic modelling There is no such thing as a free lunch. If you want to improve Power BI Copilot results for your semantic model, you should add metadata and provide the same information you should have provided to Q&A. Yes, your technical debt must still be paid. Jun 9, 2024 · Chris Webb

SQLBI YOUTUBE CHANNEL