Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 :-
Below is error msg i get :-
May i know how to solve the above issue ?
Paul
Solved! Go to Solution.
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.
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.
Hi All
thank you for response to my post.
'I think it is due to duplicate file upload.
it work fine now.
paul
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |