Connecting to PowerBI

Before you begin

In order to connect to Okera's Presto endpoint via PowerBI you will need the following:

  • Presto ODBC Driver
  • Okera's Presto Host/Port
  • Your authentication credentials (depending on what your cluster is setup to authenticate with this could be LDAP or JWT)

Download the Presto ODBC driver

You will need to download a Presto ODBC driver in order to connect to PowerBI. You can download a free version from Tableau by selecting "Presto" and then "Windows" from Tableau's drivers page. Download the last option on the page for Tableau Desktop and Server. Alternatively you can also purchase Simba's Presto ODBC Driver.

Setting up the DSN (Data Source Name)

The next step in configuring the Presto ODBC driver is setting up the DSN.

  1. Open up the ODBC Data Sources App (odbcad64.exe) on Windows ODBC driver setup

  2. Navigate to System DSN tab and press Add.

  3. Select the Simba Presto ODBC Driver.

  4. Input something for Data Source Name and Description.

  5. For Authentication Type choose LDAP.

  6. Enter your username and password. Your password will either be your LDAP credentials, or your token (depending on how your Okera cluster is configured). If token, you can grab your token by clicking on user profile icon in the bottom left corner. Copy token from Okera Web UI

  7. The Host and Port corresponds to Okera's Presto endpoint host and its port (the default is 14050). You can find this in the Okera UI by clicking on the System tab. Click the System Icon in the left navigation menu to view the endpoint. Okera System Information

  8. For Catalog enter okera

Windows Presto ODBC Driver config
  1. SSL configuration: If your ODAS cluster uses an SSL certificate from a trusted Certificate Authority, you only need to make sure SSL is checked. If you have a self-signed certificate, you’ll need to configure the Simba driver to accept self-signed certs.
Windows Presto ODBC Driver config SSL

Connecting in PowerBI

  1. In PowerBI press Get Data, and click More

  2. Navigate to Other and select ODBC

    PowerBI Connection Window

  3. Select the "Simba Presto" DSN (or whatever name you input above). Optionally, specify a query. Otherwise hit OK and select the datasets to load.

Note

When specifying a query, do not include a semicolon at the end.

PowerBI ODBC DSN PowerBI ODBC DSN