Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.