Applies to: 
Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
NoteFrom Kyvos 2024.2 onwards, exporting
|
The steps to export the semantic model metadata for Tableau Spark SQL and Kyvos ODBC are the same, as explained below.
...
Connect to Power BI using Spark SQL. See the Connecting to Power BI using Spark SQL for more details.
Export Power BI template. To do this, go to File > Export > Power BI template.
From the Toolbox, click Utilities > Export Semantic Model Metadata.
The Export Semantic Model Metadata window opens in a new tab.Select the semantic models you want to export data from by doing one of the following:
Type in the Search box to quickly find items.
Select the checkbox next to the folder or file name.
Click Select All in any of the columns to select all items shown.
Click Download Selected.
The Download Selected Semantic Model Metadata dialog is displayed.
Alternatively, click the Action menu appears on the right side of the page adjacent to the Properties pane. Click Export Semantic Model Metadata. The Download Selected Semantic Model Metadata dialog is displayed.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note By selecting this checkbox, Kyvos will create Power BI custom calculations that sends the totals and subtotals queries to Kyvos. This is required to accurately show values for advanced measures like calculated measures, semi-additive measures, and advanced hierarchies with custom rollups. |
Select the format as Power BI Data Source
...
.
Select the Power BI template from your local computer that you downloaded after connecting to Power BI using Spark SQL.
Click Convert and Download. The Semantic model is converted to a folder structure.
Open the downloaded the PBIT file in Power BI where the semantic model has been converted into a folder structure. Now, you can view the identical folder structure in Power BI as the one found in the Kyvos Web Portal.
...
| Note |
|---|
Important To obtain an accurate semantic model structure, the user should upload the latest Power BI template file to the same semantic model that they have exported using Spark SQL connector initially. . |
Default Summary functions for TDS and PBIT files
| Anchor | ||||
|---|---|---|---|---|
|
The following are the default summary functions for TDS and PBIT files when exporting semantic model metadata from Kyvos.
Tableau TDS File | Power BI PBIT File | |||
Summary Function | Without Advanced hierarchy | With Advanced Hierarchy | Without creating Power BI calculations for advanced Kyvos resources | With creating Power BI calculations for advanced Kyvos resources |
Sum | Sum | Percentile | Sum | Custom calculation |
Average | Average | Percentile | Average | Custom calculation |
Count | Count | Distinct Count | Count | Distinct Count |
Distinct count | Distinct Count | Distinct Count | Distinct Count | Distinct Count |
Min | Min | Min | Min | Min |
Max | Max | Max | Max | Max |
Semi-additive | Percentile | Percentile | Distinct Count | Custom calculation |
MDX Calculated Measure | Percentile | Percentile | Distinct Count | Custom calculation |