SQLBI Newsletter #242

NEW ARTICLE

This article describes how to optimize a text search operation in DAX. This technique can improve the performance of Power BI reports that use the contains condition in the filter pane or the filter mode of the Smart Filter Pro custom visual.
Read more

CLASSROOM COURSES

Another class in Chicago!

We are scheduling another Mastering DAX classroom course in Chicago on September 27-29, 2023. We had long waitlists for the sold-out courses in May, which is why we added another course in September. Hurry if you want a seat there!

We should publish another two dates in the US for October/November: stay tuned!
Courses schedule

#242 · May 2023

LEARNING

Course calendar

Mastering DAX

	May 17-19 - Seattle
	May 22-24 - Chic
	Jun 14-16 - Perth
	Jun 20-22 - Sydney
	Jun 26-28 - Brisbane
	Jun 27-29 - Amsterdam
	Sep 27-29 - Chicago

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
	Power Pivot

NEW VIDEO COURSE

Optimizing DAX video course - second edition

The second edition of the Optimizing DAX video course is available! Read all the details about the new content, the format, and the tools we used.
Read more

BI-WEEKLY NEWS DIGEST

Latest news

	• How to unlock new features in Power BI datasets managed with Tabular Editor Change the compatibility level of older Power BI reports by accessing new features that are in preview. Apr 25, 2023 · Kurt Buhler
	• Why load testing Power BI is important Because you don't want to pay more if your report is slow with many users! Seriously, the article provides guidance to load test tools and metrics to watch. Apr 23, 2023 · Chris Webb
	• Create Power BI reports in Jupyter Notebooks You can create a Power BI report embedded in a Jupyter notebook: bring Power BI to data scientists! Apr 24, 2023 · Microsoft
	• Heighten data literacy with the Power BI natural language Q&A visual Before ChatGPT, it was the Q&A visual that introduced natural language requests in a Power BI report. You can improve the quality of the system by providing synonyms and additional metadata. Apr 28, 2023 · David Eldersveld
	• Measuring memory and CPU usage in Power BI during dataset refresh The SQL Server profiler now provides information about the memory used to execute a DAX query. Apr 30, 2023 · Chris Webb
	• Understanding WaitTime In Power BI Another piece of information recently added to profiler events is the total wait time spent by a query waiting for available threads. DAX Studio should soon be implementing this metric to improve the accuracy of Server Timings information. May 2, 2023 · Chris Webb

SQLBI YOUTUBE CHANNEL