Setting up Power BI on-premises Gateway

Set up Power BI Gateway to connect Power BI with e6data for secure and seamless reporting.

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. Select Standard Mode (recommended for enterprise use).

  2. Download and run the installer.

  3. Follow the on-screen installation instructions.

  4. 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.

  1. Under your registered gateway, click Add Data Source and configure the following:

    • Connection Type: Starburst

    • Server Name: [your Starburst hostname]

    • Port: 443

  2. Provide authentication details:

    • Username: e6data username

    • Password: e6data Auth Token

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

Last updated