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.
The dataset was not published from Power BI Desktop.
It was automatically created in Service when the Scorecard was created following the process described in the link posted by Anonymous.
The error I receive is as follows:
Again, this is not a dataset that I created. It was generated automatically from the Scorecard and the data that was entered there.
Unfortunately, I do not know how to check the source data on the scorecard to identify where the duplicate exists. I know how to establish a live connection from Power BI Desktop to the Scorecard dataset in service, but as this dataset has not been refreshed with the latest data that contains the duplicate, this does not provide any useful information. If there was a way to connect directly to the Scorecard data other than connecting to the dataset, I'd love to hear about it!
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!
