MongoDB - Direct Query

[mathiasb17]

Hello, 

Currently i have Power Bi connected to Mongo DB with an ODBC connector that implies the "Import" Connectivity. As this Database is large, it is very long to refresh the dataset.

I want to connect Power Bi to Mongo DB using "Direct Query" as to only retrieve what's necessary. 

So far, i created a new system DSN that uses MongoDB ODBC 1.4.2 ANSI Driver. Then in Power Bi : 

1 - i selected BI Connector (as i have mongosqld running on my server, which is mongodb's bi connector)

2 -  I selected my new system DSN : 

3 - after clicking OK i typed my credentials  (please note that i get to this step even if i type a dummy dsn name that doesn't exist)

4 - i observe the same error every time, though all needed tcp/udp ports are open (and i manage to connect with the ODBC connector) :

How can i connect Power Bi to MongoDB with Direct Query ?

Thanks a lot

Mathiasb17