Microsoft Power BI #

Starburst Power BI DirectQuery driver #

The Power BI DirectQuery driver can be used with the following tools:

  • Microsoft Power BI Desktop
  • Microsoft Power BI Service

It allows Power BI to let SEP perform all query processing. This combines the scalability and power of SEP with the business intelligence reporting features of Power BI.

Requirements #

  • Power BI 2.87.720.0 and higher, older versions of PowerBI support only import mode.
  • The driver requires the OBDC driver installed on your workstation.

Connecting with Power BI Desktop #

The driver is included as part of Power BI 2.87.720.0 and higher, and you can connect with it easily.

  • Access the Get Data dialog
  • Select Other
  • Use Starburst Enterprise
  • Choose your Data Connectivity mode and proceed with OK
  • Configure the necessary connection and authentication details for your cluster. More information on authentication can be found in the following sections.
  • After the connection is established, you can use the Data Navigator to browse catalogs, query data sources and more.

The driver always tries to connect with an encrypted connection first. If you are connecting without TLS/SSL, the connector offers the option to connect using an unencrypted connection afterwards.

To use a TLS encrypted connection to your cluster, make sure the server uses a globally trusted certificate.

If this is not the case, the server’s certificate needs to be added to the system trust store (Certificates -> Trusted Root Certification Authorities) ​before connecting. 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.

LDAP authentication with Power BI Desktop #

If your cluster is configured to use LDAP authentication, select LDAP in the authentication window when connecting 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 initialized using 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.

You have to request the driver as a .mez file from Starburst Support, when using the Power BI service.

As a next step you have to copy the file into %USER%\Documents\Power BI Desktop\Custom Connectors for each user. Create the directory, if it does not exist.

The gateway service account needs to have sufficient permissions to access the Custom Connectors directory, C:\Users\<Name>\Documents\Power BI 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
  • Enter the corresponding host and port
  • Set the authentication as desired
  • Click Add to create the data source and begin using it

Limitations #

  • Self-signed certificate usage for TLS/SSL connections is not supported.
  • Writing and using custom SQL statements is not supported.
  • ODBC driver can be used for custom SQL but it does not support direct querying.
  • Authentication type and field name customization does not apply on Power BI Service. The following is the mapping of the Service field names to their Desktop counterparts:
Service name Desktop name
Basic LDAP
Key Kerberos
Key: Account Key Kerberos: Service Name

Release notes #

Version 2.0.0 #

April 2021:

  • Remove beta flag.
  • Change name to Starburst Enterprise as breaking change. All existing reports break, and all users need to recreate their queries.