Docs Menu
Docs Home
/
BI Connector
/
Connect BI Tools

Connect from Microsoft Power BI Desktop

On this page

  • Prerequisites
  • Procedure

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 to Atlas SQL from Power BI.

Prerequisites

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

Procedure

1

Start Power BI Desktop.

2

Select an ODBC Data Source Name

From the Home screen:

  1. Select the Get Data tab.

  2. Click More...

    Screenshot of Power BI list of data sources
    click to enlarge

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

    Screenshot of Power BI list of data sources
    click to enlarge

  4. Select your ODBC data source name from the list and click OK.

    Screenshot of Power BI list of data sources
    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.

Screenshot of Power BI list of data sources
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.