/ /

Connect from Microsoft Power BI Desktop

The MongoDB Connector for Business Intelligence for Atlas and on-premises reaches end-of-life (EOL) and will no longer be supported after September 2026. For all new projects, we recommend using the new MongoDB SQL Interface to connect to Atlas or Enterprise Advanced deployments. The SQL Interface offers improved performance, a simplified setup, and enhanced features. To learn more, see Connect With SQL.

This tutorial demonstrates how to connect to the MongoDB Connector for BI using Microsoft Power BI Desktop.

Important

The MongoDB Connector does not support Direct Query in Power BI. However, Atlas SQL does support Direct Query in Power BI. To connect to Atlas SQL from Power BI, see Connect from Power BI.

Prerequisites

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

Procedure

Start Power BI Desktop.

Select an ODBC Data Source Name

From the Home screen:

Select the Get Data tab.
Click More...
click to enlarge
Select ODBC from the list of data sources and click Connect.
click to enlarge
Select your ODBC data source name from the list and click OK.
click to enlarge

Select the Data to Work With

The Power BI Navigator shows a list of databases. Select a database and one or more collections to work with. A preview of your data appears to the right.

Screenshot of Power BI list of data sources

click to enlarge

Click Load when your selection is complete.

Begin Working with Power BI

Your selected data is available for use with Power BI's visualization tools.