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

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