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.

Open up the ODBC Data Sources App (odbcad64.exe) on Windows
Navigate to System DSN tab and press Add.
Select the Simba Presto ODBC Driver.
Input something for Data Source Name and Description.
For Authentication Type choose LDAP.
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.
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 on the System page.
For Catalog enter okera.

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.

Connecting in PowerBI¶

In PowerBI press Get Data, and click More…
Navigate to Other and select ODBC

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