Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
If I have two tables, one with 100 rows and one with 90 rows, I want to join them and I expect to have 100 rows in the merged table.
What kind of join do I have to use. I used full outer join, bot the result was about twice thr number of rows.
Solved! Go to Solution.
@gtamir Use the "Left Outer" option. but you need to select the large table as the first one.
View solution in original post
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
