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

[kenfolsom]

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

[Anonymous · Accepted solution]

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

[kenfolsom]

thanks I'll pass this along!

Ken