> For the complete documentation index, see [llms.txt](https://docs.e6data.com/query-engine/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.e6data.com/query-engine/developers/bi-tool-recipes/power-bi.md).

# Power BI

Connect Power BI to an e6data cluster using the Starburst ODBC driver, with optional on-premises data gateway setup.

[Power BI](https://powerbi.microsoft.com/) is Microsoft's business intelligence platform for visualizing and analyzing data. Connect it to an e6data cluster through the Starburst ODBC driver.

## Requirements

* A cluster with gateway connectivity enabled. For a Serverless cluster, enable the gateway connectivity toggle under the cluster's connection details - see [Endpoints and cluster ingress](broken://pages/Wh4d9jql2OPH1ux7JE4O).
* [Power BI Desktop](https://powerbi.microsoft.com/en-us/downloads/).
* The Starburst ODBC driver, installed.
* Your connection credentials:
  * **Username** - used to log in to e6data.
  * **Password** - a [personal access token](/query-engine/guides/security/access-tokens/pat-and-service-account-keys.md).
  * **Host** - the host of the cluster.
  * **Database** and **Catalog** (optional) - the database and catalog names.

## Connect

1. Open Power BI Desktop.
2. Go to **Home → Get data**, search for the **Starburst** connector, and click **Connect**.
3. Enter the connection details:
   * **Host** - the cluster host.
   * **Port** - `443`.
   * **Catalog** (optional) - the catalog name.
   * **Import / DirectQuery** - choose based on your needs. For a custom SQL query, qualify tables as `database.schema.table`.
4. Click **OK**. On the next screen, choose **LDAP**, enter your e6data username and personal access token, and click **Connect**.
5. Select the catalog and tables to visualize, then click **Load**.

You can now build charts and run SQL queries against e6data in Power BI.

## On-premises data gateway

To let the Power BI Service reach e6data for scheduled refresh or live queries, configure Microsoft's on-premises data gateway.

### 1. Download and install

1. Go to the [Microsoft gateway install guide](https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install).
2. Select **Standard mode** (recommended for enterprise use), download, and run the installer.
3. Sign in with your Power BI (Azure) credentials.

### 2. Register the gateway

1. Choose **Register a new gateway** (or migrate, restore, or take over an existing one).
2. Provide a unique gateway name.
3. Set a recovery key - you'll need it to restore the gateway later.

### 3. Configure the data source

1. In the [Power BI Service](https://app.powerbi.com), go to **Settings → Manage connections and gateways**.
2. Under your gateway, click **Add data source** and set:
   * **Connection type** - Starburst
   * **Server name** - your cluster host
   * **Port** - `443`
3. For authentication, enter your e6data username and personal access token.

### 4. Enable refresh or live query

* **Import mode:** open the dataset settings, enable **Scheduled refresh**, and set the frequency and time zone.
* **DirectQuery / live connection:** keep the gateway always online; Power BI queries in real time.

Install the gateway on a dedicated server or VM (not a workstation), keep it online and updated, and use Power BI's gateway monitoring to track availability.

## Troubleshooting

**`SSL certificate problem: unable to get local issuer certificate`** - install the Amazon Root CA certificates:

1. Go to the [Amazon Trust repository](https://www.amazontrust.com/repository/).
2. Under **Root CAs**, download all five certificates using the DER option in the Self-Signed Certificate column.
3. Open each certificate and select **Install Certificate → Current User → Automatically select the certificate store → Finish**.
4. Verify under **Start → Manage computer certificates → Trusted Root Certification Authorities → Certificates** - you should see Amazon Root CA 1, 2, and so on.
5. Restart Power BI and reconnect.

## Limitations

* Drag-and-drop of `date` and `datetime` types is not supported.
* Joining multiple tables in the Power BI data model is not supported; use a custom SQL query to join.
* Some functions may not be supported in measures and calculated columns.

## See also

* [Endpoints and cluster ingress](broken://pages/Wh4d9jql2OPH1ux7JE4O)
* [Access tokens](/query-engine/guides/security/access-tokens.md)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.e6data.com/query-engine/developers/bi-tool-recipes/power-bi.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.