Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

Kyvos semantic models can now be connected from Microsoft Power BI through Data Analysis Expressions (DAX) connectivity. You can run DAX queries on the Kyvos semantic model for accelerated analysis on Power BI. Additionally, you can use DAX functions to create calculated measures. Furthermore, it also supports row-level security for Power BI. 

Connecting Kyvos semantic models to Power BI through DAX

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

1. Open the Power BI Desktop application.

2. On the Home ribbon, go to Data and select Get Data > Analysis Services.
   The SQL Server Analysis Services database dialog box is displayed. 

3. Here, enter details as:

   1. Server: This is the server URL. Enter as http://<ServerName>:<port>/<kyvos>/xmlaKyvosSSO?version=v2
      Here,
      <ServerName> is the IP address or Hostname
      <Port> is the port number on which the Kyvos Web Server resides
      <kyvos> is the web app name
      <v2> represents DAX

   2. Database: Provide the Database name, which is your Kyvos semantic models folder name. 
      NOTE: Skipping the database name will prompt the application to search for the cube in the Root folder. The application will establish a connection if the cube is located in the Root folder. Otherwise, an error message is displayed. 

4. Choose the Connect live mode and click OK.

   Open

   

5. Once the connection is created, you will see the list of Kyvos cubes in the Navigator section on the left. Select the semantic model that you want to browse and click Ok.

   Open

   

   After loading the semantic model into Power BI, you will see the Kyvos semantic model in the Data section on the right. This allows you to view and access data from the semantic model quickly.
   
   

Configuring Gateway on Power BI Services 

If you want to publish the same Kyvos dashboards (created on Kyvos cubes) to Microsoft Power BI Services, you must configure a gateway, as explained below.

Requirements

Minimum requirements

• .NET Framework 4.7.2 (Gateway release December 2020 and earlier)

• .NET Framework 4.8 (Gateway release February 2021 and later)

• A 64-bit version of Windows 8 or a 64-bit version of Windows Server 2012 R2 with current TLS 1.2 and cipher suites

• 4 GB disk space for performance monitoring logs (in the default configuration)

Recommended

• An 8-core CPU

• 8 GB of memory

• A 64-bit version of Windows Server 2012 R2 or later

• Solid-state drive (SSD) storage for spooling.

Step1: Download the Gateway Installer 

Step 2: Install an on-premises data gateway | Microsoft Docs

Step 3: Use the on-premises data gateway app | Microsoft Docs  

Step 4: Add a data source 

To add a data source, perform the following steps. 

1. Open the Power BI Desktop application. 

2. On the Home page, in the upper-right corner of the Power BI service, select the Settings icon,  then  Manage connections and gateways . 

3. Click the New icon to add a new data source.  

4. On the New Data source dialog box, enter details as:

   1. Gateway cluster name: Select from the available list.

   2. Data source name: Provide a name.

   3. Data source type: Select the Analysis Services option.

   4. Server: Enter Kyvos server DAX connection string in the http://<ServerName>:<port>/<kyvos>/xmlaKyvosSSO?version=v2
      Here,
      <ServerName> is the IP address or DSN name of your Kyvos server
      <Port> is the port number on which Kyvos listens
      <kyvos> is the web app name

   5. Database: Provide the database name.

      1. Authentication Method: Select the Windows option as the authentication method

      2. User/Password: Provide the user name and p assword to connect to the Analysis Services instance. The gateway uses the information you enter for the user name and password to establish a connection with the Analysis Services instance.
         NOTE: To create a user name, you need to include both the domain name and the required user name.

   6. General: Configure the  Privacy level  for your data source.  By default, the Organizational option is selected. You can select the required option as needed.   

   7. Map Usernames: Select the EffectiveUserName option. By selecting this option, the Kyvos database will use the logged-in user name of the Microsoft Power BI services to retrieve the data.

After you complete all the fields, click Create. 

Related topics: 

• Supported DAX functions