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. 

...

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 semantic model in the Root folder. The application will establish a connection if the cube semantic model is located in the Root folder. Otherwise, an error message is displayed. 

4. Choose the Connect live mode and click OK.

   

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

   

   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 cubessemantic models) to Microsoft Power BI Services, you must configure a gateway, as explained below.

Requirements

Minimum requirements

...

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.

...