Connect from Microsoft Power BI Desktop

On this page

Prerequisites

Procedure

This version of the documentation is archived and no longer supported. View the current documentation instead.

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

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.