...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Applies to: 
Kyvos Enterprise Kyvos Azure Marketplace
Kyvos AWS Marketplace Kyvos Free (
...
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.
| Info | ||
|---|---|---|
| ||
The Microsoft Power BI SSAS connector only supports Windows authentication. Therefore, configuring Windows Authentication in Kyvos is mandatory to use the Microsoft Power BI SSAS/DAX connector. |
...
- Open the Power BI Desktop application.
- On the Home ribbon, go to Data and select Get Data > Analysis Services.
The SQL Server Analysis Services database dialog box is displayed. - Here, enter details as:
- 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 - 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.
- Server: This is the server URL. Enter as http://<ServerName>:<port>/<kyvos>/xmlaKyvosSSO?version=v2
- Choose the Connect live mode and click OK.
- 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.
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
| Info |
|---|
A workbook created on the public cluster does not require a gateway. |
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
...
- Open the Power BI Desktop application.
- On the Home page, in the upper-right corner of the Power BI service, select the Settings icon, then Manage connections and gateways .
- Click the New icon to add a new data source.
- On the New Data source dialog box, enter details as:
- Gateway cluster name: Select from the available list.
- Data source name: Provide a name.
- Data source type: Select the Analysis Services option.
- 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 - Database: Provide the database name.
- Authentication Method: Select the Windows option as the authentication method
- 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.
- General: Configure the Privacy level for your data source. By default, the Organizational option is selected. You can select the required option as needed.
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.
Info title Info Prior to using the EffectiveUserName option, y our email address, which is used for Power BI services, must be configured with Kyvos users. See the Users section for more details.
- After you complete all the fields, click Create.
...
Related topics: