Microsoft Power BI Desktop

This article explains how to connect Microsoft Power BI Desktop to an Exasol database.

Exasol takes no responsibility for changes in functionality or terms of use for third-party tools. For more details about the compatibility and use of these tools with Exasol, refer to the respective software vendor’s website.

Introduction

Microsoft Power BI is Microsoft’s business analytics platform that consists of two components: the Power BI Desktop application and the Power BI service. A certified custom connector for Exasol is integrated in Power BI Desktop and in the on-premises data gateway, enabling you to connect to Exasol using Direct Query mode as well as classical import mode.

This article explains how to connect Power BI Desktop to an Exasol database using the Exasol connector. For more information about how to use the Power BI software services, apps, and connectors, refer to the Power BI documentation on the Microsoft Learn website.

Prerequisites

  • Microsoft Power BI Desktop must be installed.

  • The Exasol ODBC driver must be installed. To learn more, see ODBC Driver.

  • Your Exasol database must be running and reachable from the environment where Microsoft Power BI Desktop is installed.

Connect Power BI Desktop to Exasol

  1. In the Power BI Desktop application, create a new database connection and select the Exasol connector.

  2. Set the following options:

    Connection String: The hostname or IP address to the database, or a list of all nodes in a cluster.

    For example: 203.0.110.11 or 203.0.110.11..13

    Encrypted: Yes

    Data Connectivity Mode: DirectQuery

    enter connection string

  3. Enter the username and password for the Exasol database, then click on Connect to finish.

    enter credentials

Next steps

To learn how to use Power BI Desktop and the on-premises data gateway, refer to the Power BI documentation on the Microsoft Learn website.