Dremio Jekyll

Connecting Power BI Gateway to Dremio

Brock Griffey


Overview


Often, customers using Dremio with Power BI have the need to move to Power BI Gateway . In order to set this up, customers will need to follow a few steps to get live connections with Dremio.


Requirements


  • Dremio Cluster
  • System for PBI Gateway to run from (must be on 24x7 for live queries)
  • Power BI Desktop (for publishing)
  • Admin account for the Power BI website

Setup Power BI Gateway with the Power BI Site


  1. Download & install the Dremio ODBC drivers. Make sure to checkmark the Power BI connector as well. image alt text
  2. Download Power BI Gateway.
  3. Install Power BI Gateway on the machine that will be running the bridge. The gateway must be available whenever a user interacts with the Power BI Dashboard on the Power BI website, otherwise queries will fail.
  4. Open the gateway software and navigate to the connectors section. Select the custom folder that the Dremio ODBC driver installed. C:\Program Files\Dremio Connector\Microsoft Power BI. The Dremio connector should show up now. image alt text
  5. Go to https://app.powerbi.com/
    1. Open settings
    2. Click the Manage gateways and select the gateway that was just installed image alt text
    3. Check the “Allow user’s custom data connectors to refresh through this gateway cluster”
    4. Click “Add data source to use the gateway” image alt text
    5. Name your data source and select Dremio from the Data Source Type dropdown
    6. Fill out the connection information
    7. Set the encryption to Not Encrypted
    8. Save image alt text

Setup a Dashboard and publish


  1. Create a simple VDS in Dremio.
  2. Open the VDS in Power BI Desktop and create a simple workbook to be published.
  3. Make sure to sign into your Microsoft account.
    1. In Power BI Desktop click publish
    2. Sign-in to https://app.powerbi.com/

Test Power BI live connection


  1. Open your workbook on the Power BI site.
  2. Verify the connection is submitting queries directly to Dremio.
    1. Open Dremio and check the jobs, make sure Power BI is submitting queries to Dremio.

After completing these steps, there should now be a live connection between the Power BI site and Dremio