Forum Discussion

kn_capgemini's avatar
kn_capgemini
Regular Visitor
1 year ago

Log Analytics - refresh failure

Hi everyone, 

 

for some time now I keep getting the same error in log analytics reports. this applies not to one but to several reports on different workspaces.

 

the error below:

 

Column '<oii>Query Suboperation Key</oii>' in Table '<oii>Operation</oii>' contains a duplicate value 'da6facf9-9d3b-xxx' 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: Operation.

 

I use report template provided by Microsoft: https://github.com/microsoft/PowerBI-LogAnalytics-Template-Reports/blob/main/PBIASEngine/README.md

 

has anyone had a similar issue?