> ## Documentation Index
> Fetch the complete documentation index at: https://honeydew.ai/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Power BI Integration

## Connection Setup

Power BI connects to Honeydew via ODBC driver using the Trino protocol.

### Power BI Desktop

Honeydew uses the Trino protocol to connect to Power BI. In order to connect, an ODBC driver needs to be installed.

#### Driver installation

In order to complete the installation, you should have the following (please reach out to [support@honeydew.ai](mailto:support@honeydew.ai) to obtain access):

1. Access to a shared folder containing the following files:
   * `Simba Trino 2.3 64-bit.msi`
   * `Honeydew.mez`
2. Received `SimbaTrinoODBCDriver.lic` license file over email

Follow these installation steps:

1. Install the **Simba ODBC driver** (`Simba Trino 2.3 64-bit.msi`). By default, it will be installed in `C:\Program Files\Simba Trino ODBC Driver\`.
2. Place the `SimbaTrinoODBCDriver.lic` license file in the following folder: `C:\Program Files\Simba Trino ODBC Driver\lib\`.
3. Place the `Honeydew.mez` file in the custom connectors directory: `C:\Users\<user>\Documents\Power BI Desktop\Custom Connectors`.
   Create the folder if it doesn't exist.

<Tip>
  To discover the custom connectors folder path on your system,
  you can use one of the following methods:

  **Option 1 - Using Command Prompt:**

  ```bash theme={null}
  echo "%USERPROFILE%\Documents\Power BI Desktop\Custom Connectors"
  ```

  **Option 2 - Using PowerShell:**

  ```powershell theme={null}
  # Original string
  $path = "%USERPROFILE%\Documents\Power BI Desktop\Custom Connectors"

  # Expand environment variables
  $fullPath = [Environment]::ExpandEnvironmentVariables($path)

  # Print it
  Write-Output $fullPath
  ```
</Tip>

<Note>
  If you are syncing your documents with Microsoft OneDrive, the file path may vary.
  If the Honeydew connector is not appearing in the list of available connectors in Power BI Desktop,
  consider checking the following paths.
  You may need to create the folders in your OneDrive directory if they do not already exist:

  * `C:\Users\<user>\OneDrive\Documents\Power BI Desktop\Custom Connectors`
  * `C:\Users\<user>\OneDrive - XXXX\Documents\Power BI Desktop\Custom Connectors`
</Note>

#### Initial Setup

1. Open Power BI Desktop
2. In case you get a notification about "Uncertified Connectors":
   * In order to be able to use the connector, please go to **Options and Settings** > **Options** > **Security**, and set the **Data Extensions** setting to "Allow any extension to load without validation or warning":
     <img src="https://mintcdn.com/honeydew/YIHua7Tb-EdKa7vx/images/PowerBI-Data-Extensions-Settings.png?fit=max&auto=format&n=YIHua7Tb-EdKa7vx&q=85&s=7efbccd115f8c477eb41c2da570d83f1" alt="Data Extensions" width="1094" height="196" data-path="images/PowerBI-Data-Extensions-Settings.png" />
   * Restart Power BI Desktop
3. In Honeydew, go to the menu of an existing workspace, and click **Power BI** > **Download datasource**. A \*.pbit file will get downloaded.
4. Open the downloaded \*.pbit file in Power BI Desktop.
5. Go to **File** > **Options and settings** > **Data source settings**. The following connect dialog will open up:
   <img src="https://mintcdn.com/honeydew/YIHua7Tb-EdKa7vx/images/PowerBI-Connector-Creds-1.png?fit=max&auto=format&n=YIHua7Tb-EdKa7vx&q=85&s=c70f560704edb96be2360e87e657e40c" alt="Data Source Settings" width="1590" height="1216" data-path="images/PowerBI-Connector-Creds-1.png" />
6. Click "Edit Permissions...". The following dialog will open up:
   <img src="https://mintcdn.com/honeydew/YIHua7Tb-EdKa7vx/images/PowerBI-Connector-Creds-2.png?fit=max&auto=format&n=YIHua7Tb-EdKa7vx&q=85&s=b9f4a4e879e8fd6e648aaa89101435e1" alt="Edit" width="796" height="788" data-path="images/PowerBI-Connector-Creds-2.png" />
7. Click **Edit**. The following dialog will open up:
   <img src="https://mintcdn.com/honeydew/YIHua7Tb-EdKa7vx/images/PowerBI-Connector-Creds-3.png?fit=max&auto=format&n=YIHua7Tb-EdKa7vx&q=85&s=b97cc4d4818515608fab0d9e74671d5f" alt="Connect" width="1392" height="640" data-path="images/PowerBI-Connector-Creds-3.png" />
8. Choose the **OAuth** option, and click **Sign in**.
9. You can now use the datasource downloaded from Power BI - it has a direct connection to Honeydew.

### Power BI Service

#### Power BI Gateway Installation

Honeydew connects to Power BI Service by using the [Power BI gateway](https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem).
See the [installation manual](https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install) on how to install an on-premise gateway.
If you are unable to have a Power BI gateway in your organization, please contact [support@honeydew.ai](mailto:support@honeydew.ai).

#### Driver Installation & Power BI Gateway Setup

In order to complete the installation, you should have the following (please reach out to [support@honeydew.ai](mailto:support@honeydew.ai) to obtain access):

1. Access to a shared folder containing the following files:

* `Simba Trino 2.3 64-bit.msi`
* `Honeydew.mez`

1. Received `SimbaTrinoODBCDriver.lic` license file over email

Follow these installation steps:

1. Install the **Simba ODBC driver** (`Simba Trino 2.3 64-bit.msi`). By default, it will be installed in `C:\Program Files\Simba Trino ODBC Driver\`.
2. Place the `SimbaTrinoODBCDriver.lic` license file in the following folder: `C:\Program Files\Simba Trino ODBC Driver\lib\`.
3. Place the `Honeydew.mez` file in the custom connectors directory that can be accessible by the Power BI Gateway.
   By default that is `C:\Windows\ServiceProfiles\PBIEgwService\Documents\Power BI Desktop\Custom Connectors`.
   Create the folder if it doesn't exist.
4. Complete the steps as described in the
   [**Enable and use custom connectors**](https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-custom-connectors#enable-and-use-custom-connectors) section.

#### Creating a Data Source Connection in Power BI Service

After setting up the Power BI Gateway and installing the required drivers, you need to create
a data source connection in Power BI Service to connect to Honeydew.

<Tip>
  It is recommended to use an [API Key](/docs/access-control/api-keys) for setting up the connection.
</Tip>

1. Sign in to [Power BI Service](https://app.powerbi.com/)
2. Click the gear icon in the upper-right corner and select **Manage connections and gateways**
3. In the **Connections** tab, click **New** to add a new data source
4. Configure the connection with the following details:
   * **Gateway cluster name**: Select your configured gateway
   * **Connection name**: Enter a descriptive name (e.g., "Honeydew Connection")
   * **Data source type**: Choose **Honeydew** from the list of available connectors
   * **Server**: Enter `jdbc.honeydew.cloud`
   * **Port**: Enter `443`
   * **Authentication method**: Choose **LDAP**
   * **Username**: Enter your Honeydew API key or username
   * **Password**: Enter your Honeydew API secret or password
5. Click **Apply** to create the data source connection
6. Click **Close** to close the data source settings dialog

<Note>
  If your organization uses a custom hostname for the JDBC connection,
  you can locate it in the Honeydew UI, under the **JDBC** section in **Settings**
</Note>

#### Publishing a model from Power BI Desktop

1. Load a semantic model on Power BI Desktop (as described [here](#initial-setup)), that is connected to Power BI Service.
2. Save the model as a \*.pbix file.
3. Publish the saved model to the Power BI Service.
4. Open the model in the Power BI Service.
5. You can now build reports on top of the published model or use the model directly from Power BI Service.

#### API Integration

The Power BI API integration enables direct publishing of semantic models
from Honeydew to the Power BI Service without requiring manual download of a `*.pbit` / `*.pbix` files.

You can find instructions on how to set up API integration with Power BI [here](/docs/integration/bi-tools/powerbi-api-integration).