3.6. Starburst Power BI DirectQuery Driver#
The Power BI DirectQuery Driver can be used to connect Microsoft Power BI Desktop and Microsoft Power BI Service to SEP. It allows you to connect to Presto with Power BI, where the query processing is performed in Presto instead of all the data moved to Power BI for processing.
Contact Starburst support to receive the driver as a
Prerequisite ODBC Driver#
The driver requires the ODBC driver detailed in Starburst ODBC Driver to be installed.
Installation for Power BI Desktop#
In order to allow usage of the driver, you need to allow loading of extensions without validation or warning in Power BI Desktop. Configure this in File -> Options and Settings -> Options -> Security -> Data Extensions.
Next close Power BI and copy the
.mez file into
Desktop\Custom Connectors for each user. Create the directory, if it does not
Restart Power BI and you can locate Starburst Enterprise Presto as a source in the Get data dialog.
Connecting with Power BI Desktop#
The driver always tries to connect with an encrypted connection first. If you are connecting without SSL/TLS, the connector offers the option to connect using an unencrypted connection afterwards.
To use an SSL/TLS encrypted connection to your SEP server, make sure the server’s certificate is added to the system trust store (Certificates -> Trusted Root Certification Authorities) before connecting to a SSL/TLS-enabled. The certificate can be added for the machine, or for each user running the Power BI connector. In many organizations this handled automatically as part of the operating system and browser configuration.
Once added, connections work transparently to the user:
Select Starburst Enterprise Presto as source in the Get Data dialog.
Choose your Data Connectivity mode and proceed with OK.
Continue with the desired authentication detailed below.
After the connection is established, you can use the Data Navigator to browse catalogs, query data sources and more.
LDAP Authentication with Power BI Desktop#
If your SEP server is configured to use LDAP authentication, select LDAP in the authentication window when connecting to Presto and provide your username and password credentials.
Kerberos Authentication with Power BI Desktop#
To use Kerberos authentication, Kerberos must be installed for the user and
kinit, before using the driver. This establishes your user
credentials on the machine.
Select Kerberos in the authentication window, when connecting, and provide the Kerberos Service name.
Connecting with Power BI Service#
Using the Power BI service, requires you to have the on-premises data gateway for Power BI installed on your machine.
In addition, the gateway service account needs to have sufficient permissions to
Custom Connectors directory,
Desktop\Custom Connectors inside your Power BI installation.
Update the directory properties in the Security - Advanced tab. Add access that grants Basic Permissions - Full Control to Everyone / Authenticated Users. Alternatively, you can also create a new group and add the gateway service account to a new group.
Update the value for Load custom data connectors from folders in the Connectors configuration of the gateway to point at the folder in your Power BI Desktop installation.
Login to Power BI Online and update the Gateway Cluster Settings. Enable the setting Allow user’s custom data connector to refresh through this gateway clusters.
Now you can add a data source:
Login to the Power BI service
Navigate to Setting -> Manage gateways
Select the gateway -> Add data source
Set the Data Source Type to Starburst Enterprise Presto
Enter the corresponding host and port
Set the authentication as desired
Click Add to create the data source and begin using it
Self-signed certificate usage for TLS/SSL connections is not supported.
Authentication type and field name customizations do not apply on Power BI Service. The following is the mapping of the Service field names to their Desktop counterparts:
Key: Account Key
Kerberos: Service Name