Forum Discussion
Power BI Log Analytics dataset not refreshing
If you don't have access to edit the PBI report, maybe try looking in your actual data to see if there is a duplicated value for some reason that matches that '418adf73-....' number and see if you can remove it there. Basically this error is because there is a common relationship between that number in one table and the same number in another table. Many to one means that one of the tables has that number listed many times in multiple rows and the other table should only have 1 single row reference to it. When there are duplicates in the single row reference table then it will fail like this.
I honestly don't even know how to locate the data for this report - the source is listed as a web URL beginning with https://api.loganalytics.io/v1/workspaces. I believe something had to be set up via the Azure Portal, but again, the person who set this up is not with the company anymore, and I'm not finding anything that looks right in the Portal. It sounds like I should probably ask our Azure admins to investigate further so we can hopefully locate the data.
