topic Re: COM error: mscorlib, An item with the same key has already been added.. in Report Server

COM error: mscorlib, An item with the same key has already been added..

tweidner — Thu, 14 Jan 2021 10:55:47 GMT

Hi everyone,

your help on the following issue would be highly appreciated:

I have a report sitting on PBI Report Server, which has a scheduled set up to refresh every 24hrs - no issues.

After switching to PBI RS (October 2020) Desktop, I had to do some minor changes on one of the visuals and after uploading the file to the Report Server the scheduled refreshs fails:

Report is refreshing fine on PBI RS (October 2020) Desktop version...

I was able to identify the source of the issue, which is an append step of two sources (both SAP Business WH Application Server).

Refresh is working fine on RS as soon as I delete the append step. Due to the nature of the data I wasn't able (yet) to find another solution in order to life w/o the append step.

Lookig forward to your ideas!

Best Regards
Tobias

Re: COM error: mscorlib, An item with the same key has already been added..

Anonymous — Mon, 18 Jan 2021 05:16:34 GMT

tweidner
I am not sure how is your model look like. Seems the append step is trying to add rows to a table that is originally a unique column, this step would changes the exiting model relationship causing the error. Try Append Queries as New without changing the current relationship.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Re: COM error: mscorlib, An item with the same key has already been added..

Anonymous — Mon, 25 Jan 2021 15:54:17 GMT

I had the same issue, it appears to be a bug in the new update. Fortunately I was able to recreate my tables into a view in SQL and it fixed the issue but that isn't possible for everyone! The problem is with appending tables and the naming of the columns, check if you have any columns on your merged table that have the same name as the originals (even if capitalised power bi treats them as the same)

Re: COM error: mscorlib, An item with the same key has already been added..

Anonymous — Tue, 26 Jan 2021 02:11:37 GMT

Try the solution in the mitigation method, How to Disable Enhanced Dataset Metadata
December 2020 Update – Issues Regarding Power BI R... - Microsoft Power BI Community

Paul Zheng _ Community Support Team

Re: COM error: mscorlib, An item with the same key has already been added..

tweidner — Tue, 26 Jan 2021 07:11:16 GMT

Hi Paul,

I tried both of your suggestions, but unfortunately noe of them was working.

Rgds

Tobias

Re: COM error: mscorlib, An item with the same key has already been added..

tweidner — Tue, 26 Jan 2021 07:13:21 GMT

Hi Valley Girl,

Id id review column all column headers, but I wasn't able to similar names.

Thanks & Rgds

Tobias

Re: COM error: mscorlib, An item with the same key has already been added..

tweidner — Tue, 26 Jan 2021 07:14:59 GMT

I've now appended the data sources at BW level to get the measures and attributes I'm looking for.

Therefore I don't have to append two BW datasets at PBI query level anymore.

Thank you for your replies!

Re: COM error: mscorlib, An item with the same key has already been added..

xantari — Tue, 26 Jan 2021 21:39:59 GMT

I'm also getting this error since October 2020 update.

Installed latest hotfix from 1/8/2021 on server and Power BI Desktop application.

Still getting this:

SessionID: 2a175ab7-a51c-4407-b3ee-24b65784210e
[0] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, An item with the same key has already been added..
[1] -1055784828: The database operation was cancelled because of an earlier failure.
[2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[4] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[5] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[6] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, An item with the same key has already been added..
[7] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, An item with the same key has already been added..