Connect from Power BI
On this page
This page describes how to connect to a cluster with Atlas SQL and Power BI using the Power BI Connector.
Prerequisites
An Atlas cluster running MongoDB version 5.0 or later.
Power BI Desktop 64 bit. Microsoft updates and releases Power BI monthly, and Atlas supports only the latest version of Power BI Desktop.
Windows operating system. To learn the Windows OS versions that Power BI Desktop supports, see Power BI System Requirements.
Procedure
Follow these steps to enable Atlas SQL and connect with Power BI.
Enable Atlas SQL.
Click Quick Start
Quick Start configures a federated database instance for your cluster with the default settings.
To set up Advanced Configuration, including querying across Atlas data sources or limiting the namespaces to query, you must Manually Create a Federated Database Instance for Atlas SQL.
Download the MongoDB ODBC Driver.
Download the installer for the latest MongoDB ODBC Driver.
Download and install the MongoDB Atlas Power BI Connector.
Download the connector file.
Connect from Power BI Desktop.
Enter your Atlas User name and Password and click Connect.
By default, a user can access all clusters and federated database instances in projects to which they have access. If you restricted access to specific clusters and federated database instances, you can grant access to the new federated database instance in the Edit User menu. To learn more, see Modify Database Users.