SQLBI Newsletter #269

NEW ARTICLE

Understanding apply semantics for window functions in DAX

This article explains the unique behavior of apply semantics: a new way of computing table expressions when multiple rows are selected in DAX window functions.
Read more

ANNOUNCEMENT

Licensing API for SQLBI video course

We recently released a licensing API to enable a deeper integration with our customers' HR processes, and extend our enterprise offer.
Read more

#269 · May 2024

LEARNING

Course calendar

INTRO TO DAX - 1 DAY

	May 27 - Amsterdam

Mastering DAX - 3 DAYS

	May 22-24 - Copen
	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

ADVANCED DAX - 1 DAY

	May 28 - Amsterdam

DAX OPTIMIZATION - 1 DAY

	May 29 - Amsterdam
	Aug 9 - Melbourne
	Aug 15 - Sydney

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

CLASSROOM COURSES

Mastering DAX and Data Modeling in Canada

Alberto will be in Canada in September 2024!

Calgary, AB - Mastering DAX
Vancouver, BC - Data Modeling for Power BI

Note: Vancouver is also the only Data Modeling class in North America for 2024!
Overall schedule

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI semantic model memory errors: Max Offline Semantic Model Size You can set a limit to the size of a model published to Power BI service in order to avoid possible memory errors at query time. May 5, 2024 · Chris Webb
	• New ‘ExecutionMetrics’ event in Azure Log Analytics for Power BI semantic models It is now possible to collect additional information about refresh and queries made to Power BI service to identify the root cause for several issues, including capacity throttling. Sample templates in Power BI are available to create reports on it! May 13, 2024 · Microsoft
	• The partialBatch Commit Mode In The Power BI Enhanced Refresh API If your scheduled refresh fails because of memory requirements, you can try to split the work into different transactions and lower the memory consumed. Pay attention to the errors, it requires more attention and control! May 12, 2024 · Chris Webb
	• Microsoft Fabric Conference Europe We usually do not repeat news you have probably already seen many times. But this newsletter offers very technical news and this is the first time that a Microsoft "data analytics / business intelligence" conference is held in Europe. While the hype on Fabric is big, having an event that can attract all the different roles involved in data analytics solutions is welcome information that we are happy to amplify. May 14, 2024 · Microsoft

SQLBI YOUTUBE CHANNEL