New article: Optimizing time intelligence in DirectQuery
NEW ARTICLE
This article describes how to optimize time intelligence calculations with DirectQuery over SQL in Power BI by avoiding time intelligence DAX functions.
Read more

 

SQLBI DAYS

SQLBI Days is a new format to deliver content for DAX newbies and DAX experts!

SQLBI Days
Each SQLBI Day is a different event with a different topic. To optimize the logistics, we have organized several SQLBI Days in a row in the same venue, but they cater to different audiences. For this first wave of SQLBI Days, we thought of three topics: one for DAX beginners and two for people who already know DAX well.

Chicago Amsterdam
For DAX Newbies
Introduction to DAX Apr 30 May 27
 
For DAX Pros
Advanced DAX May 1 May 28
First Steps in DAX Optimization May 2 May 29


Registrations are already open: go ahead and reserve your seat!

Read more

 

BI-WEEKLY NEWS DIGEST
Latest news
• Understanding the “Evaluation resulted in a stack overflow” error in Power Query
Even though Power Query allows recursion in M scripts, it's dangerous business. If you face a stack overflow error, you might have to rewrite your code to avoid recursion.
Jan 28, 2024 · Chris Webb
• Fix Power BI “Something is wrong with one or more fields”
When changes in the semantic model break existing reports, it can be challenging to figure out which measure or column that was removed from in the report broke a visual. Learn how to retrieve the original reference and fix it.
Jan 30, 2024 · Kurt Buhler
• Performance implications of using calculated columns in composite models on Power BI semantic models
Calculated columns are evaluated at query time in an import model, but this behavior can be different in a composite model. Learn the different behaviors depending on the model structure to remain in control.
Feb 4, 2024 · Chris Webb


SQLBI YOUTUBE CHANNEL
Latest videos