Visualizing Merge Join Types in Power BI

You can combine two queries in Power BI using the Merge Queries option (in Edit Queries). While merging queries, you will be asked for a join kind. This report visually shows what are the different j...

how to

leonardmurphy

Skilled Sharer

9 years ago

Nice work Jason (and great idea too)!

I haven't seen anything explaining joins as simple to understand as your diagram on page 2. As much as the Venn diagram is a classic, the blocks were as straightforward as side-ways Tetris to me (seeing which blocks "fall" to the right-hand column based on their presence and/or absence in the other 2 columns).

Cross joins might be worth adding to the mix (but that would not be fun to do).

SqlJason

Memorable Member

9 years ago

Thanks Leonard, though I can only take the credit for developing the actual solution. The join diagrams are inspired from this post - https://blog.jooq.org/2016/07/05/say-no-to-venn-diagrams-when-explaining-joins/ and was pointed out to me on twitter by @@thesqlgrrrl.