Unknown database error when connecting to MongoDB with ODBC

[jnberger]

Hi,

I’m trying to build a report based on data stored on local MongoDB database, with the ODBC connector.

But I’ve got the following error :

DataSource.Error: ODBC: ERROR [HY000] [MySQL][ODBC 1.0(a) Driver][mysqld-5.7.12 mongosqld v2.5.0]Unknown database ''

Details:

    DataSourceKind=Odbc

    DataSourcePath=dsn=MongoLocal64bits

    OdbcErrors=Table

Notice that it works fine on Qlik based on the same ODBC source (64 bits).

Steps to reproduce on PowerBI (Version: 2.60.5169.4101 64-bit July 2018) :

• Connect to the ODBC (no credentials)

• Click on « Table » to navigate into the demo database

• Click on « Table » to navigate into the animals collection :

Here’s the complete query to get the error :

let

    Source = Odbc.DataSource("dsn=MongoLocal64bits", [HierarchicalNavigation=true]),

    demo_Database = Source{[Name="demo",Kind="Database"]}[Data],

    animals_Table = demo_Database{[Name="animals",Kind="Table"]}[Data]

in

    animals_Table

Did someone already have this error and fixed it ?

Regards.

JN.

[connect]

Here is the solution... Thanks to all the other posts. If you want to see it in action, here is the answer!!

[v-jiascu-msft · Accepted solution]

Hi JN.,

We found the cause. We should add the Database explicitly. Please check it out.

Best Regards,

Dale

[lucaziegler]

Your solution is not acceptable because the link to the image is available, please post it in to the solution directly!

[jnberger]

Hi Dale,

Thanks for your great help !

I think that there's a bug somewhere because the database was actually selected in the query :

demo_Database = Source{[Name="demo",Kind="Database"]}[Data]

But your workaround is fine and it works for me.

Best regards.

JN.

[v-jiascu-msft]

Hi JN,

I tested with almost the same settings as yours. It seems fine. Can you share your "drdl" file? But I don't think that will be a problem. BTW, my MongoDB is the latest community version hosted in Ubuntu 16.04. 

Can you share a snapshot of the ODBC settings, please?

Best Regards,

Dale