Exporting semantic model metadata

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

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

You can export semantic model metadata for use with other applications. Use these options to export a semantic model that you want to use for analysis within Tableau and Power BI. 

When you export the semantic model data for Tableau, you need to indicate which Tableau version it will be used with. You don't need to provide connection details, as the metadata and connection information are included. 

For Tableau, verify the server IP address, port, and username to use for the connection to the original semantic model source or update it if needed. The username must have rights to the semantic model data.

Choose one of the following formats:

• Tableau Data Source (Spark SQL)

• Tableau Data Source (Kyvos ODBC). The Tableau version should be 2019.4 or later. 

• Power BI Data Source

The steps to export the semantic model metadata for Tableau Spark SQL and Kyvos ODBC are the same, as explained below. 

Exporting semantic model metadata for Tableau 

To export semantic model metadata, perform the following steps. 

1. From the Toolbox, click Utilities > Export Semantic Model Metadata.
   The Export Semantic Model Metadata window opens in a new tab.

2. Select the semantic models you want to export data from by doing one of the following: 

   1. Type in the Search box to quickly find items.

   2. Select the checkbox next to the folder or file name.

   3. Click Select All in any of the columns to select all items shown.

3. Click Download All or Download Selected.
   The Download Selected Semantic Model Metadata dialog is displayed. 
   
   

   Open

   

   
   Alternatively, click the Action menu appears on the right side of the semantic model page next to the Properties pane. Click Export Semantic Model Metadata. The Download Selected Semantic Model Metadata dialog is displayed. 
   
   

   Open

   

4. Choose the format and specify the Tableau version. 

5. Update the Server IP and port details if needed, or use the ones listed.

6. Select Save Username in file to save the username with the data.
   If you select this option, use the default choice or enter a username.

7. Click Download.

As a separate process, you will need to upload the resulting file to the destination where you intend to use it.

Exporting semantic model metadata for Power BI

To export semantic model metadata for Power BI, perform the following steps. 

1. Connect to Power BI using Spark SQL. See the Connecting to Power BI using Spark SQL for more details. 

2. Export Power BI template. To do this, go to File > Export > Power BI template. 

3. From the Toolbox, click Utilities >  Export Semantic Model Metadata.
   The Export Semantic Model Metadata window opens in a new tab.

4. Select the semantic models you want to export data from by doing one of the following: 

   1. Type in the Search box to quickly find items.

   2. Select the checkbox next to the folder or file name.

   3. Click Select All in any of the columns to select all items shown.

5. 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. 

6. Select the format as Power BI Data Source (Spark SQL).  

7. Select the Power BI template from your local computer that you downloaded after connecting to Power BI using Spark SQL. 

8. Click Convert and Download. The Semantic model is converted to a folder structure. 

9. 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.

Default Summary functions for TDS and PBIT files

The following are the default summary functions for TDS and PBIT files when exporting semantic model metadata from Kyvos.