cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bbearchell Frequent Visitor
Frequent Visitor

Merge Error for duplicates for primary key when it's not the primary key.

Hey guys im trying to merge these two tables.

merge.png

After I hit apply though it keeps giving me this error, which doesnt make sense since im not merging on that column and it's not the primary key.

error.png

Any help would be greatly appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
v-xjiin-msft Super Contributor
Super Contributor

Re: Merge Error for duplicates for primary key when it's not the primary key.

Hi @bbearchell,

 

Yes, it is odd. 

 

And generally, if you are doing the right steps in Merge option. It will display a correct message under the Join Kind. Like:

 

7.PNG

 

However, there's no message in your screenshot. Could you please share us your pbix file with One Drive or Google Drive if possible? Otherwise it is hard for us to say where the issue is.

 

Thanks,
Xi Jin.

 

View solution in original post

2 REPLIES 2
v-xjiin-msft Super Contributor
Super Contributor

Re: Merge Error for duplicates for primary key when it's not the primary key.

Hi @bbearchell,

 

Yes, it is odd. 

 

And generally, if you are doing the right steps in Merge option. It will display a correct message under the Join Kind. Like:

 

7.PNG

 

However, there's no message in your screenshot. Could you please share us your pbix file with One Drive or Google Drive if possible? Otherwise it is hard for us to say where the issue is.

 

Thanks,
Xi Jin.

 

View solution in original post

bbearchell Frequent Visitor
Frequent Visitor

Re: Merge Error for duplicates for primary key when it's not the primary key.

My coworked messed up a previous table. 5 hours of headscratching. It was an easy fix

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 168 members 1,687 guests
Please welcome our newest community members: