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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Paulyeo11
Impactful Individual
Impactful Individual

Case 973 When i load target table i get error msg on duplicate value on date field

Hi All

 

I already have sales table and i try to add sales target table. i manage to get it link up. 

 

Now when i try to apply on my acutal data , When i try to load below target table :-

Paulyeo11_1-1604573441159.png

 

Below is error msg i get :-

 

Paulyeo11_0-1604573394050.png

May i know how to solve the above issue ?

Paul

1 ACCEPTED SOLUTION
mussaenda
Super User
Super User

Hi @Paulyeo11 ,

 

first, remove the relationship.

then, reload the data.

It will not show any error regarding duplication.

 

Then investigate the duplication of data. You can do a count and see all the duplication.

After fixing your duplicatin issue, create the relationship again.

 

hope this helps.

 

 

 

View solution in original post

4 REPLIES 4
mussaenda
Super User
Super User

Hi @Paulyeo11 ,

 

first, remove the relationship.

then, reload the data.

It will not show any error regarding duplication.

 

Then investigate the duplication of data. You can do a count and see all the duplication.

After fixing your duplicatin issue, create the relationship again.

 

hope this helps.

 

 

 

Paulyeo11
Impactful Individual
Impactful Individual

Hi All

thank you for response to my post. 
'I think it is due to duplicate file upload.

it work fine now.

paul

Anonymous
Not applicable

Well, is there a duplicate in the source file..? You can obviously solve it by removing this duplicate. 

 

If it's there and you need it you will have to change your relationship between TARGET and the other table. Go to "Modeling" -> "Manage relationsships" -> "Edit" on the relationship with TARGET -> Change cardinality to Many-to-Many" or "One-to-Many" and continue. Do understand your might need to aggregate information now as one date can hold multiple records. 

 

If there is no duplicate, check the Power Query Editor to find out where the error occurs.

amitchandak
Super User
Super User

@Paulyeo11 , check your Date table and traget table realtion, It should be 1 to M from date to Target. If not edit relation and modify that

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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