Forum Discussion

TR_KY_PBI's avatar
TR_KY_PBI
Frequent Visitor
4 years ago

Scorecard Refresh Failure - Duplicate 'Id' in 'Values' table

Working with a client to build a ScorecardScorecard for their leadership team.  It utilizes both linked an unlinked goals.     I am going to build a Power BI report with a live connection to the Sc...
Need Help
SimpsonDM's avatar
SimpsonDM
Frequent Visitor
4 years ago

TR_KY_PBI did you manage to resolve this issue?

 

I am hitting the same error.

 

I am creating goals via the PBI api, when the dataset is then refreshed the following error is presented:

 

Data source errorColumn '<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.

 

After adding my first goal I was able to refresh the dataset and see that the values table had a record with a blank value in the Id column. I assume on adding my second goal via the API, this also generates a record in the values table with a blank Id - which is then erroring due to duplicates when the dataset is refreshed.

 

It would be great to hear if you had any success with this.

 

Thanks

  • TR_KY_PBI's avatar
    TR_KY_PBI
    Frequent Visitor
    4 years ago

    Hi SimpsonDM -

     

    Unfortunately, I ended up having to re-make the entire scorecard.  We were still early in the deployment, so we didn't loose anything other than a few hrs of work.  Very frustrating.  However, we have been running for several weeks now w/o issue.  We were creating goals manually, rather than via API.

     

    • SimpsonDM's avatar
      SimpsonDM
      Frequent Visitor
      4 years ago

      I've at least figured out what the issue was

       

      When you create a goal without an initial value, the service seems to add a record to the values table with a blank id. If you add a second goal, also without a value, then it throws the error above (duplicate value '<pii></pii>')

       

      To get around this, once I created the goals I added an initial check in for some time in the past that would be outside of my current date range (01/01/2000). Once this check in was added for all goals, I was able to refresh the dataset without issue.