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

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