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
Visit the official Microsoft download page: https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install
Select Standard Mode (recommended for enterprise use).
Download and run the installer.
Follow the on-screen installation instructions.
After installation, sign in using your Power BI (Azure) credentials.
Setup Step 2: Register the Gateway
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)
Provide a unique Gateway Name.
Set a Recovery Key — this will be required if you need to restore the gateway later.
Setup Step 3: Configure Data Source Connections
Go to the Power BI Service: https://app.powerbi.com
Navigate to Settings > Manage Connections and Gateways.
Under your registered gateway, click Add Data Source and configure the following:
Connection Type: Starburst
Server Name: [your Starburst hostname]
Port: 443
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