an item with the same key has already been added error

[alsasloren]

Hi guys,

I searched something about this error message but all of them are old and related with 2017 october release.

So i couldn't find any available solution.

I'm trying both import and direct query methods to connect SAP BW.

One of the query in my datasource is returning this error message, the others are working.

I couldn't find anything on SAP BW side.

any idea ?

[me1548]

Hi,

I am getting this error as well in Power Bi Report Builder - version 15.6.1340.2.  The sql query works elsewhere (TOAD, BIRT), but complains of this error with no details of which column is the problem.  Is there anything else I can look at or set to figure this out?

Thanks

[alsasloren · Accepted solution]

After changing on BW Bex Query format, it started to working. 

[amitchandak]

@alsasloren , this not on SAPBW but for mysql -https://community.powerbi.com/t5/Desktop/Unexpected-error-An-item-with-the-same-key-has-already-been...

Power bi is case insensitive for Table and Column names, Just check if that is causing issue