> For the complete documentation index, see [llms.txt](https://docs.e6data.com/product-documentation/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/product-documentation/connectors-and-drivers/power-bi/setting-up-power-bi-on-premises-gateway.md).

# Setting up Power BI on-premises Gateway

This setup guide helps you configure Microsoft’s on-premises data gateway to enable Power BI to access data through e6data securely. By following these steps, you can register a gateway, configure data source connections, and support both scheduled refresh and live query modes in Power BI.

### Setup Step 1: Download and Install the Gateway

1. Visit the official Microsoft download page: <https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install>
2. Select **Standard Mode** (recommended for enterprise use).
3. Download and run the installer.
4. Follow the on-screen installation instructions.
5. After installation, sign in using your **Power BI (Azure)** credentials.

### Setup Step 2: Register the Gateway

1. Once signed in, choose one of the following options:
   * **Register a new gateway** (for first-time setup)
   * **Migrate, restore, or take over an existing gateway** (if applicable)
2. Provide a unique **Gateway Name**.
3. Set a **Recovery Key** — this will be required if you need to restore the gateway later.

### Setup Step 3: Configure Data Source Connections

1. Go to the Power BI Service: <https://app.powerbi.com>
2. Navigate to **Settings > Manage Connections and Gateways**.

<figure><img src="/files/hzbJOH75Rw2xwZbXSsaK" alt=""><figcaption></figcaption></figure>

3. Under your registered gateway, click **Add Data Source** and configure the following:
   * **Connection Type**: Starburst
   * **Server Name**: \[your Starburst hostname]
   * **Port**: 443
4. Provide authentication details:
   * **Username**: e6data username
   * **Password**: e6data Auth Token

<figure><img src="/files/KMnNoFVJrJkbFhbFni4L" alt=""><figcaption></figcaption></figure>

### Setup Step 4: Enable Data Refresh or Live Query

For **Import Mode Reports**:

* Open your dataset settings in Power BI
* Enable **Scheduled Refresh**
* Set your **refresh frequency** and **time zone**

For **DirectQuery or Live Connection**:

* Make sure the gateway is **always online**
* No scheduling is needed; Power BI will query the data source in real time

### Best Practices

* Install the gateway on a **dedicated server or virtual machine**, not on a personal workstation or laptop
* Ensure **stable network connectivity** and high uptime on the machine hosting the gateway
* **Update the gateway software regularly** to apply performance improvements and security fixes
* Use Power BI’s **gateway monitoring tools** to track availability and refresh success