Connecting to MongoDB using ODBC

[Anonymous]

Hi, 

I have the data stored in a MongoDB. I use ODBC to bring the data to PowerBI.

It has worked for a few months, but suddenly when I try to refresh the data I get this error:

"ODBC: ERROR [42S21] [MySQL][ODBC 1.2(w) Driver][mysqld-5.7.12 mongosqld v2.11.0]Duplicate column name 'KEY_COLUMN_USAGE.CONSTRAINT_CATALOG'".

I tried in the Get Data advanced options, added a SQL statement ("SELECT * FROM robot-inits;") but the error still remains.

Any ideas what could be happening?

Thanks!

[Anonymous · Accepted solution]

The issue was because MongoDB released an update. The problem was solved by apllying the update to our DB.

Thanks!

[Anonymous]

Can you tell me where you got the update from. We are facing similar issue and want to know where we can download the update.

Thanks,

Raj

[TeigeGao]

Hi @Anonymous ,

In this scenario, I would suggest you using other application to test this ODBC source for troubleshooting.

Best Regards,

Teige