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 join kinds as well as show the resulting merged table. eyJrIjoiYmNhNzgzYjAtNjc2OS00YjQwLTgwNzItM2Q1MzcyMmJlYjMyIiwidCI6IjZjMGE1YjljLTA4OWEtNDk0ZS1iMDVlLTcxNjEwOTgyOTA0NyIsImMiOjF9

Synoptic Panel. Just made a simple png using PowerPoint and then used the Synoptic Designer to create the 3 areas within the Venn chart. I initially thought of using the Visio custom visual, but then remembered that you will need to make the visio file public with everyone to publish this report to the web. This visual requires One Drive for Business (so I don't have a personal account) and right now, my company does not allow sharing files publicly. So could not use the Visio option.

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.

This is pretty interesting SqlJason ! Good work.

Hi Jason, I expanded on your sample and I notice that when you do Cross Join it show correct value in power query (5x4=20)But when you try to show in power bi table visual you get only 15 records (5x3) ?How do you correct that? see attachments Thanks, Oded Dror

Jason, Please Discard the previous question I fix it Thanks, Oded Dror

Visualizing Merge Join Types in Power BI | Microsoft Fabric Community

14 Replies

ketan10
Advocate III
9 years ago
This is pretty interesting SqlJason ! Good work.
Anonymous
Not applicable
6 years ago
Hi Jason,

I expanded on your sample and I notice that when you do Cross Join it show correct value in power query (5x4=20)
But when you try to show in power bi table visual you get only 15 records (5x3) ?
How do you correct that? see attachments

Thanks,

Oded Dror
- Anonymous
  Not applicable
  6 years ago
  Jason,
  
  Please Discard the previous question I fix it
  
  Thanks,
  
  Oded Dror
deldersveld
Resident Rockstar
9 years ago
Are you using the Visio custom visual for the main join diagram?
- SqlJason
  Memorable Member
  9 years ago
  Synoptic Panel. Just made a simple png using PowerPoint and then used the Synoptic Designer to create the 3 areas within the Venn chart.
  
  I initially thought of using the Visio custom visual, but then remembered that you will need to make the visio file public with everyone to publish this report to the web. This visual requires One Drive for Business (so I don't have a personal account) and right now, my company does not allow sharing files publicly. So could not use the Visio option.
  - deldersveld
    Resident Rockstar
    9 years ago
    Thanks. I see Synoptic's zoom control now. I haven't spent any time with the Visio preview.
Anonymous
Not applicable
6 years ago
Good Job!
peachela
Regular Visitor
1 year ago
Thank you for your effort, very helpful.
TuralAHmadov
New Member
9 months ago
Hi SqlJason,
I really liked your report on “Visualizing Merge Join Types in Power BI”.
Could you please share the .pbix file with me?

Thank you in advance!
TuralAHmadov
New Member
9 months ago
Hi SqlJason,
I really liked your report on “Visualizing Merge Join Types in Power BI”.
Could you please share the .pbix file with me?

Thank you in advance!