cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Patron
Post Patron

an item with the same key has already been added error

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 ?

1 ACCEPTED SOLUTION
Post Patron
Post Patron

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

View solution in original post

3 REPLIES 3
New Member

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

Post Patron
Post Patron

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

View solution in original post

Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors