The CData Power BI Connector for MongoDB is built on top of an ODBC driver. This section discusses how to install the connector, create a DSN, and connect from Power BI.

Installing the Connector

Installing the Connector is a step-by-step guide for how to manage the installation process.

Creating a Data Source Name (DSN)

Creating the Data Source Name describes the process to authenticate and connect to MongoDB.

MongoDB Version Support

The connector models MongoDB instances as relational databases and supports MongoDB versions 2.6 through 7.0. The connector leverages the MongoDB API, including the MongoDB aggregation framework, to enable bidirectional SQL access to MongoDB data. See the NoSQL Database chapter for SQL-to-MongoDB query mappings and more information about accessing unstructured data in MongoDB through SQL. See the DBaaS Connections page to connect to popular services such as Atlas and ObjectRocket.

For an introduction to Visualizing Data using the CData Power BI Connector for MongoDB.