Forum Discussion
Random but common Error Column 'WorkItemId' in Table 'WorkItems' contains a duplicate value
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
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
thanks I'll pass this along!
Ken