Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

An entry with the same key already exists.

Hi Team,    We are refreshing the data for already built report. I am getting the error 'An entry with the same key already exists.' Below is the log for that. We have tried to clear the permission...
Need Help
karthiksoorya2's avatar
karthiksoorya2
New Member
3 years ago

Root cause is in the Database, not in the Power BI.

There are 2 objects with the same in Database.

 

For example,
There could be a Table as "SalaryDetail"

There could be a Function as "SalaryDetail"

This is possible in MySQL.

 

When PowerBi is connecting the Database, it is collecting database objects as metadata and started storing by object name in its internal collection for reference. 

Object name is the unique key in that metadata collection to identify.

So,

When PowerBI is trying the add table object first name as "SalaryDetail", it will be added.

When PowerBI is trying the add function object first as "SalaryDetail", the collection throws an error the key already exists.

 

So the DB design,  should be updated.

 

Karthik