Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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?
Solved! Go to Solution.
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.
Proud to be a Super User!
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
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
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.
Proud to be a Super User!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
69 | |
54 | |
37 | |
35 |
User | Count |
---|---|
86 | |
68 | |
59 | |
51 | |
46 |