Unknown database error when connecting to MongoDB with ODBC

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.