cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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

 

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

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

 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors