New article: Optimizing text search in DAX
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
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
 

NEW VIDEO COURSE
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
Latest videos