Forum Discussion

kenfolsom's avatar
kenfolsom
New Member
9 years ago
Solved

Random but common Error Column 'WorkItemId' in Table 'WorkItems' contains a duplicate value

Hello

 

 We had a third party create reports for us using VSTS interfaces and when refreshing the data we have randomlyl occuring errors that won't reproduce the next day or when you manually refresh. Any ideas?

 

 

An error occurred while processing the data in the dataset.

Column 'WorkItemId' in Table 'WorkItems' contains a duplicate value '35380' 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.

Next refresh for [BETA] Sprint Reports (v0.43) is scheduled for 02/24/2017 03:00:00.

Learn more

Technical Information:

Activity Id: 5dd75dcd-c933-47ef-a075-2ad92b9e0aa0

Request Id: 3652298d-9887-406e-bbda-aa5a7db10d23

Cluster Name: WABI-WEST-US-redirect.analysis.windows.net

Refresh Start Time: 02/23/2017 10:04:08Z

Refresh End Time: 02/23/2017 10:07:38Z

Thanks,

Microsoft Power BI

This email was sent by Microsoft Corporation

One Microsoft Way
Redmond, WA, 98052, USA

Privacy Policy | Terms and Conditions

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi kenfolsom,

     

    >>We had a third party create reports for us using VSTS interfaces and when refreshing the data we have randomlyl occuring errors that won't reproduce the next day or when you manually refresh. Any ideas?

     

    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.

     

    Regards,
    Xiao xin Sheng

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi kenfolsom,

     

    >>We had a third party create reports for us using VSTS interfaces and when refreshing the data we have randomlyl occuring errors that won't reproduce the next day or when you manually refresh. Any ideas?

     

    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.

     

    Regards,
    Xiao xin Sheng