Connecting Power BI to MongoDB Server

Working with Data Connectors & Integrations
1

I have a MongoDB Community installation, on an Ubuntu 18.04 server. I can connect to it fine, using Compass from my desktop.

I would like to connect PowerBI Desktop to my MongoDB Server. I tried the instructions here:

https://docs.mongodb.com/bi-connector/current/connect/powerbi/

Specifically:

downloaded the MongoDB Power BI Connector
Installed it
Get Data
More
ODBC
Connect

But, here’s what I get:

Screen Shot 2020-05-21 at 14.32.32
Screen Shot 2020-05-21 at 14.32.32935×332 6.49 KB

No option to selected the BI Connector SDN per instructions. Any ideas? Also, other than downloading the MongoDB PowerBI Connector, any ideas how to connect?

2

Have you tried creating a DSN? It is one of the required steps. Once you do, you should be able see it in the drop down and select it to create the connection.

PowerBI connectors typically store all the connection information (server name, port, database, username…) in the DSN.