How to connect to Mongo DB via ODBC connection on PowerBI service

[jenniferho]

Hi guys,

My data source is locating in MongoDB (I have still yet checking with the vendor whether MongoDB is located in Atlas or somewhere on the premise)

On Power BI service, I would like to create a dataflow, then get data from MongoDB via ODBC connector.

May I ask anyone know what exactly should I fill in the follwoing so that I will be able to connect to the data source?

sorry I am a newbie to ODBC connection and MongoDB.

ODBC connection string (anywhere should I find this / I should be able to attain this from the vendor)
On-premises data gateway (where should the data gateway be created? at the location where the mongo DB situates?)
Authentication kind (what should i fill in)

Many thanks.
J

[v-easonf-msft · Accepted solution]

Hi , @jenniferho 

I don’t have mangodb here for testing, but I think it should be similar to the creation process of other databases odbc.

Please try following steps:

1. get an existing Mango database ,download the latest PowerBI desktop Version

2. Install the latest  Mango DB ODBC driver

3.  create a 64-bit system Data Source Name (DSN).

4. connect to your ODBC

https://docs.mongodb.com/bi-connector/master/reference/odbc-driver

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

If you are trying to create a dataflow in service,you may also need to create a datasource in gateway first .

Datsource Type:ODBC
Connect string: dsn= your datasource name
Authentication Method: Basic

Here is a related thread about how to connect   to IBM DB2 database  via ODBC  in PowerBI Service.You can refer to it :

https://community.powerbi.com/t5/Service/Enterprise-Gateway-with-ODBC/td-p/98959

Best Regards,
Community Support Team _ Eason