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.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi,
I am trying to create a new table that shows me all values of table B for each of the values in table A. I cannot use the merge option without a relationship nor the append option without getting a bunch of null values. Attached you will find some pictures of what I am trying to accomplish in the Power Query Editor.
Thanks so much for the help!
Solved! Go to Solution.
@Anonymous What you are looking for looks to be a cross join. You can follow the steps here to show you how to do it: Cross join | Microsoft Docs
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
Thank you very much!!
It works perfectly!
@Anonymous What you are looking for looks to be a cross join. You can follow the steps here to show you how to do it: Cross join | Microsoft Docs
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.