Forum Discussion
MongoDB ODBC Connection
Hi,
There is a MongoDB dataflow and it has failed multiple times. The connection is an ODBC connection in PowerBI (dsn, unicode driver 1.3.0).
ODBC: ERROR [HY000] [MySQL][ODBC 1.3(w) Driver][mysqld-5.7.12 mongosqld v2.13.4]Table 'backpack-production.appraisal_manualAdjustments' doesn't exist
3 Replies
- Hi Anonymous,
Just to be sure: have you made sure that table exists by connecting to it in Power BI Desktop or another client application for example?Hi nickyvv the object manualAdjustments does exist in the MongoDB. It isn't a required field to be filled out by the customer.
Hi Anonymous ,
Please try to upgrade MongoDB Connector for BI and MongoDB ODBC Driver to the latest version.
Please refer to https://www.mongodb.com/try/download/bi-connector
https://github.com/mongodb/mongo-odbc-driver/releases
If the issue is still existing, would you please try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Best Regards,
Dedmon Dai
