Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Merging 2 Tables with no Relationship

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!

 

Example.png

1 ACCEPTED SOLUTION
DataZoe
Microsoft Employee
Microsoft Employee

@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/

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Thank you very much!!

It works perfectly!

DataZoe
Microsoft Employee
Microsoft Employee

@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/

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

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.