Go to websiteCommunityContact Us

Get Data from Semantic Model

This section explains the steps to connecting to data in a semantic model.

PowerTable allows you to connect to an existing semantic model and create an app. The data table, along with any changes or updates, is written back to your preferred data platforms.

In this case, the source and destination are different.

The steps are as follows:

  1. Go to your Microsoft Fabric workspace folder. Click on New item to create a new item.

Create a new item

  1. Select PowerTable from the list of items. You may want to add it to your favorites by clicking on the star icon.

Select 'PowerTable'

  1. Enter a name for your PowerTable app and select the workspace. Click on Create.

Create PowerTable item

  1. Click on Create a New App to create your app. You may also select 'Explore PowerTable' to experience a sample PowerTable app.

Create a New App

  1. Creating a new database connection: The next step is to create a new database connection to your preferred data source. Your app writes back its data to this data store destination. Follow the steps below to create a new connection:

  • Click on New Connection.

  • Choose your preferred data platform. We'll connect to the Fabric SQL database for writeback.

  • Click Next.

Creating a new connection

If you already have shared database connections or a private connection to the required data store, skip step 5. Instead, click on the 'Existing Connection' tab, select the one you want to use, and then click Next.

Choosing an existing connection

  1. Setup Connection: Enter the connection type and a unique connection name. Select the workspace and the database from the list of options and click Next. Your new private connection is now created.

Setup Connection

  1. Select your table where the data will be stored/written back: Here, you have two options:

    1. Select Existing Table to connect to an existing table in the database (or)

    2. Select New Table to create a new table in the database.

    We'll select New Table to create a new table where we will writeback the source data acquired from the semantic model.

Create new table

  1. Enter the following details:

  • Schema and Table Name: Select the schema and enter a name for the table.

  • Import Data: Choose the option Connect To Semantic Model.

  • Workspace and Semantic Model: Enter the name of the workspace in which your semantic model exists, as well as the name of the semantic model you want to connect to and get data from. Click Next.

Connect to semantic model

Capacity workspaces with Pro licences are not supported. Please make sure to select a workspace of premium capacity.

  1. Map Data: The next step is to map and assign your data. Assign the required fields and values to the table.

Assign fields and values

  1. Filter: You can use the filter to select specific fields in the table, if necessary.

Filter required fields

  1. Schedule Refresh: You can also schedule periodic data source refreshes to ensure your data is up to date with the semantic model.

To schedule a refresh, enable the toggle. Then, set the refresh frequency, scheduled duration and time, time zone, and option to skip specified calendar holidays. Click Next after previewing the data.

Schedule refresh

  1. PowerTable automatically detects the fields' data and input types and the primary key. You can edit them, if necessary. You can also add additional columns in this step, using the Add Column option. After verifying the details, click Finish.

Configure Table

The table app has been successfully created using PowerTable, with the configured columns and values.

Table app created

You can start working with this data and make changes as needed. The changes are written back to the configured data platform destination.

You can configure access control, workflows, approvals, automation and other features for your new app. These are covered in the upcoming sections.

PreviousEnter Data ManuallyNextBasic Table Operations

Last updated