MySQL connection error without native SQL query

[technolo_bi]

I am trying to connect (get data) to one of the MySQL databases and receive an error: "An entry with the same key already exists".

I can't even see what tables are available.

When I use native SQL query or try to connect to other DB then problem doesn't occur.

[v-yalanwu-msft]

Hi, @technolo_bi ;

Clear permissions in data source settings and try the latest version of Power BI Desktop.

It seems that the error is essentially a duplicate column name error,

https://answers.sap.com/questions/5955946/a-row-with-the-same-key-already-exists.html

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[technolo_bi]

Hi @v-yalanwu-msft,

I can't even select a table, so where should I look for duplicate column?

[kamil2]

I have the same problem. Thanks in advance for any help!