Connecting to Microsoft Power BI through Kyvos ODBC Connector

To connect Kyvos semantic models to Power BI, perform the following steps.

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

   

2. In Kyvos ODBC Connector, provide the following details:

   1. Kyvos Server: <IP>:<Port>

   2. HTTP Path: kyvos/sql

   3. Use SSL: Enabled or Disabled

   4. Data Connectivity mode: DirectQuery

      

3. Click Ok.

4. Select the authentication mode. Select one of the following authentication methods:

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

      

   2. OAuth 2.0: Click Sign In.

      

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

         

      2. Click Connect.

         

5. On the Power BI Navigator window, select your database and select the Kyvos semantic model.

   

6. Click Load. This connects Power BI to the selected Kyvos semantic model for visualization.