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

deldersveld

Resident Rockstar

9 years ago

Thanks. I see Synoptic's zoom control now. I haven't spent any time with the Visio preview.

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.