/
Connecting to Microsoft Power BI through Kyvos ODBC Connector

Connecting to Microsoft Power BI through Kyvos ODBC Connector

Note

To use the Kyvos ODBC connector, you must install the Kyvos ODBC driver 4.0 or above.

To connect to Microsoft Power BI through ODBC Connector, see:

Prerequisites

This connector is designed for use with Microsoft Power BI and works most effectively when the Kyvos ODBC Driver is installed on the machine running the Power BI application.

Capabilities supported

  • DirectQuery (Power BI semantic models)

Connect to Kyvos from Microsoft Power BI Desktop

To connect Kyvos from Power BI Desktop, perform the following steps.

  1. Open Power BI Desktop, navigate to Get Data, select the Kyvos ODBC connector, and click Connect. The Kyvos ODBC dialog is displayed.

    image-20240611-094147.png

  2. On the Kyvos ODBC dialog box , provide the following details:

    1. Kyvos Server: Enter the server details

    2. HTTP Path: kyvos/sql

    3. Use SSL: Enabled or Disabled

    4. Data Connectivity mode: DirectQuery

      image-20250303-085946.png

  3. Click Ok.

  4. Select any one of the authentication mode:

    1. Username and password: Provide Kyvos Web Portal credentials and click Connect.

      image-20240929-173731.png

    2. OAuth 2.0: Click Sign In.

      image-20240611-095611.png

      1. You will be redirected to a third-party Identity. To authenticate, provide your Identity Provider (IDP) credentials and then click Sign In.

        image-20240611-094928.png

      2. Switch to Power BI Desktop, and you will be signed in.

      3. Click Connect.

        image-20240611-105140.png

  5. On the Power BI Navigator window, select the Kyvos semantic model, and click Load. This connects Power BI to the selected Kyvos semantic model for visualization.

    image-20250303-090120.png

Connect to Kyvos from the Microsoft Power BI service

If your data source is directly accessible to the Power BI Services, you will need not to configure a gateway connection. Otherwise, you must configure the gateway as explained below:

Step 1: Download and Install the Gateway | Microsoft Docs

Step 2: Configure the on-premises data gateway app | Microsoft Docs

Note

  • User impersonation is not supported with Kyvos ODBC connector.

  • Kyvos ODBC driver must be installed in the machine where the Power BI gateway is installed.

To connect to Kyvos from Power BI service, perform the following steps.

image-20240929-174149.png

To connect to Kyvos from Power BI Service, perform the following steps.

  1. Open Power BI service.

  2. Go to Settings > Manage connection and gateway.

  3. Choose the Connection tab and then select New.

  4. On the New Connection page, provide the required details.

    1. Enter the Gateway cluster name.

    2. Enter the Connection name.

    3. Select Kyvos ODBC from the Connection Type list.

    4. Enter the Kyvos Server name. Enter the server details.

    5. Enter the HTTP Path as kyvos/sql.

    6. Enter the Enabled or Disabled option from the Use SSL list.

  5. Choose an authentication method:

    1. Username and Password: Enter your Kyvos credentials.

      image-20240930-112849.png

    2. OAuth 2.0: Select Edit credentials and authenticate through IDP.

      image-20240930-112954.png

    3. Choose the required Privacy level.

    4. Select Create.

    5. Go to published semantic model > Settings > Gateway and cloud connections, select the required Gateway, and then Maps to appropriate connection.

    6. Select Apply.

    7. Now open the published Power BI workbook.

      image-20240929-180718.png

Copyright Kyvos, Inc. 2025. All rights reserved.