Skip to content

Latest commit

 

History

History
47 lines (31 loc) · 3.32 KB

powerbi_custom_connector.md

File metadata and controls

47 lines (31 loc) · 3.32 KB

Microsoft Power BI Desktop - Using Amazon DocumentDB Custom Connector

The custom connector only supports DocumentDB username and password for authentication.

Prerequisites

Before you get started, make sure the Amazon DocumentDB ODBC driver is installed properly.

Follow these instructions to enable custom connector on Power BI.

Copy the AmazonDocumentDBConnector.mez file to the <User>\Documents\Power BI Desktop\Custom Connectors\ folder (or to <User>\OneDrive\Documents\Power BI Desktop\Custom Connectors if using OneDrive). This will let Power BI access custom connector.

  • Restart Power BI Desktop.

Connecting using the Amazon DocumentDB custom connector

  1. Select Amazon DocumentDB (Beta) from Get Data and click Connect. You may get a warning for using third-party service. Click on Continue. Code Coverage Windows

  2. Enter all necessary information to connect to your DocumentDB cluster. Code Coverage Windows Note Hover on the info button to see what is the default value if the attribute is not provided. Code Coverage Windows

  3. Choose between Import Mode or Direct Query Note: Import mode loads all data and stores the information on disk. The data must be refreshed and reloaded in order to show data updates. Direct Query mode does not load data, but does live queries on the data. This means that data does not need to be refreshed and reloaded in order to show data updates. Custom Connector - Import Mode vs Direct Query Mode

    Note: If you are using a very large dataset, importing all of the data may take a long time.

  4. If this is the first time connecting to this data source, select the authentication type and input your credentials when prompted. The authentication types available are: Code Coverage Windows

    • DocumentDB Credentials: Enter DocumentDB username and password.

    Once you are done, click Connect.

  5. In the Navigator, select the database tables you want, then either select Load to load the data or Transform Data to continue transforming the data. Code Coverage Windows Notes:

  • Your Data Source Settings are saved once you connect. To modify them, select Transform Data > Data Source Settings.

Microsoft Power BI Gateway

Important notes to make sure that the custom connector will work with Power BI Gateway

  1. Make sure that the ODBC DSN is created in the ODBC data sources in the System tab on the machine that Power BI Gateway is installed.

  2. If you are using the internal SSH tunnel feature, the file known_hosts needs to be placed where the Power BI Service account can access it. known_hosts file permission

    Note this also applies to any file(s) that you might need to be able to establish a connection to your DocumentDB cluster, like if you need to use a pem certificate file to connect to your DocumentDB cluster.