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

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)

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

Hi Valley Girl,

 

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

 

Thanks & Rgds

Tobias