Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

You can export semantic model  metadata 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. 

...

  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.

...

Note

Important

To obtain an accurate semantic model structure, the user should upload the Power BI template file to the same semantic model that they have exported using Spark SQL connector initially.