Docs Menu

Docs HomeMongoDB Atlas

Connect from Power BI Desktop (Windows)

Important

Feature unavailable in Serverless Instances

Serverless instances don't support this feature at this time. To learn more, see Serverless Instance Limitations.

For M10+ clusters that have enabled the BI Connector for Atlas, the Connect dialog provides the details to connect via the BI Connector for Atlas.

Screeenshot of the Atlas BI connection dialog.
  • Atlas cluster with BI Connector for Atlas enabled

  • Create a system Data Source Name (DSN)

1
2

From the Home screen:

  1. Select the Get Data tab.

  2. Click More...

    Screenshot of Power BI list of data sources
  3. Select ODBC from the list of data sources and click Connect.

    Screenshot of Power BI list of data sources
  4. Select your ODBC data source name from the list and click OK.

    Screenshot of Power BI list of data sources
3

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 Load when your selection is complete.

4

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

For more information on the MongoDB Connector for Business Intelligence, see MongoDB Connector for BI Manual.

Share Feedback
© 2023 MongoDB, Inc.

About

  • Careers
  • Investor Relations
  • Legal Notices
  • Privacy Notices
  • Security Information
  • Trust Center
© 2023 MongoDB, Inc.