Forum Discussion
Scorecard Refresh Failure - Duplicate 'Id' in 'Values' table
Hi TR_KY_PBI ,
If you are using this function in the link below？
Create scorecards and manual goals in Power BI (preview)
If not, is that the dataset called scorecard is connected in Desktop and an error is reported during the data conversion?Could you please provide a screenshot with the issue.
“Column '<pii>Id</pii>' in Table '<pii>Values</pii>' contains a duplicate value '<pii></pii>' ”. The pii column now have duplicate value. Please check that does the Id column of the table Values in the data source actually contain duplicate values?
If your report is publish from Power BI Desktop, I'd like to suggest you add custom steps to filter the duplicate records at Power Query side.
If you directly get data from service side, I think it is impossible to modified at Power BI Service, you need to deal with these duplicate records at interface side.
I have also found a similar post, please refer to it to see if it helps you.
Dataset refresh failed due to primary key violation
- Solution 1 (Recommanded) - Remove duplicates from Email column in Power Query window
- Solution 2 - Update the relationship to Many to Many
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello All,
Did anyone had luck on the issue?
I am facing same issue and using out of box scorecard functionality in Power BI. when trying to connect to scorecard in Power BI desktop as dataset via "live connection" the below error pops-up.
Column '<pii>Id</pii>' in Table '<pii>Values</pii>' contains a duplicate value '<pii></pii>' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. Table: Values.
Its very strange that it is working few weeks before and all of sudden the issue popsup.
Thank you for any insights. Highly appreciate your time and support!