Versions Compared

Old Version 3

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version Current

changes.mady.by.user Sarabjeet Kaur

Saved on

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

...

  • Tableau Data Source (Spark SQL)

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

  • Power BI Data Source (Spark SQL) 

...

  •  

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

From Kyvos 2024.2 onwards, exporting semantic model metadata in a TDS or PBIT file will include the Kyvos measure format. This format will be applied when the file is imported into Tableau or Power BI, respectively.

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 

...

  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.