Forum Discussion
Connecting to MongoDB using ODBC
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!
- Anonymous7 years ago
The issue was because MongoDB released an update. The problem was solved by apllying the update to our DB.
Thanks!
3 Replies
- TeigeGao
Solution Sage
Hi Anonymous ,
In this scenario, I would suggest you using other application to test this ODBC source for troubleshooting.
Best Regards,
Teige
- AnonymousNot applicable
The issue was because MongoDB released an update. The problem was solved by apllying the update to our DB.
Thanks!
- AnonymousNot applicable
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