# 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="https://3484040590-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FeVBYKZm1xFKFFVzS0lRJ%2Fuploads%2FsZrve8QFFmbCcLWXUFsX%2Fimage.png?alt=media&#x26;token=c189c39d-ac0a-41b5-9486-bd8751712117" 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="https://3484040590-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FeVBYKZm1xFKFFVzS0lRJ%2Fuploads%2FLPmvRuwf6MfQNSxwz0jj%2Fimage.png?alt=media&#x26;token=71c7975d-f2d3-4f4d-960d-65733c141f77" 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