Forum Discussion

tweidner's avatar
tweidner
Icon for Helper I rankHelper I
5 years ago
Solved

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

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. Afte...
COM Error
Report Server
  • tweidner's avatar
    tweidner
    5 years ago

    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!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.