MongoDB - Direct Query

Anonymous — Tue, 24 Nov 2020 09:53:16 GMT

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

topic MongoDB - Direct Query in Developer

MongoDB - Direct Query