For AI agents: a documentation index is available at https://www.mongodb.com/docs/llms.txt — markdown versions of all pages are available by appending .md to any URL path.
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.
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
3
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.
click to enlarge
Click Load when your selection is complete.
4
Begin Working with Power BI
Your selected data is available for use with Power BI's visualization tools.
