Error while using OLE DB connection

[darshaningale]

I am using an oracle native connection from Power BI Desktop. However as the data load speed is very less i found out that OLE DB connection will be faster. 

However when i try to use OLE DB connection with the same Oracle credentials , I am getting the error as 

"An entry with the same key already exists".

I have no clue what the error is.

Can you please guide ?

[v-lionel-msft]

Hi @darshaningale ,

Are there some columns with the same field name in your data table?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[darshaningale]

Do you mean i have two columns with the same name ?

I donot have those.

[v-lionel-msft]

Hi @darshaningale ,

Yes, did you check your columns?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[darshaningale · Accepted solution]

i couldnt resolve the issue but i added a select query with required columns and the table in the advanced section. That gave me my data.. However i still say the issue persists because i think only some versions of Power BI is giving that error.