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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Merging in Power Query

Merge always gives me a headache. 

Situation is:  

I have a table of opportunities with an Opportunity ID.     I have another table, called Quotes, that contains the Opportunity ID as well...but also has the column I need in my Opportunity table, which is, the Order number from our ERP table.   

 

I thought by merging the tables, using the Opportunity ID  with a Left Outer join would give me all my Opportunities in my current table, but then bring in just the Order number from the SF quote table.     I essentially want to match the Opportunity ID from both tables, so that for those Opportunities that have been coverted, the Order number will show up in the new column.  

 

But in doing so I went from 9600 rows in my Opportunity table, to 23000.    Is it possibly a granularity issue?

1 ACCEPTED SOLUTION
vanessafvg
Super User
Super User

have you checked the rowcounts on both tables?     Is it not possible that a customer has more than one quote but then i suppose the opportunity id would be different?  If not check for duplications.  What are you joining on?  best to share some of the data.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Anonymous
Not applicable

HI @Anonymous,

Any update for these? Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

Anonymous
Not applicable

Hi @Anonymous,

How about use relationship mapping two tables instead of directly merge these tables in the query editor?

For this scenario, you can extract two table id field values and use them to create a bridge table with unique keys to link two tables.

How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive

Regards,

Xiaoxin Sheng

vanessafvg
Super User
Super User

have you checked the rowcounts on both tables?     Is it not possible that a customer has more than one quote but then i suppose the opportunity id would be different?  If not check for duplications.  What are you joining on?  best to share some of the data.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.