Forum Discussion
COM error: mscorlib, An item with the same key has already been added
Thank you for the reply Denis. Unfortunately it didn't work for me but it might help someone else.
However I did find a solution to my problem.
Our report created its SQL data source in 2 distinct ways for some reason, using 1 or 2 lines:
Source = Sql.Database("HOSTNAME", "DATABASENAME"),
or
Source = Sql.Databases("HOSTNAME"),
DATABASENAME = Source{[Name="DATABASENAME"]}[Data],Apparently when we merged 2 tables using different source creation methods it would crash in Report Server. I changed all our data source to use the single line method and now everything works.
That definitely sounds like a bug, I will create an issue report.
Hello,
I had the same issue, to solve I renamed columns that use as keys in join operation. How I have new error
So I can't say that it can help. But, perhaps, it a good idea to try.
In my case joined quereis came from Query to folder with Excel files and query to Excel file.
Report Server version
Thank you for the reply Denis. Unfortunately it didn't work for me but it might help someone else.
However I did find a solution to my problem.
Our report created its SQL data source in 2 distinct ways for some reason, using 1 or 2 lines:
Source = Sql.Database("HOSTNAME", "DATABASENAME"),
or
Source = Sql.Databases("HOSTNAME"),
DATABASENAME = Source{[Name="DATABASENAME"]}[Data],
Apparently when we merged 2 tables using different source creation methods it would crash in Report Server. I changed all our data source to use the single line method and now everything works.
That definitely sounds like a bug, I will create an issue report.
Thank you for the reply JeanMartinL. Unfortunately it didn't work for me but it might help someone else.
