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. Choose your table where the data will be stored: 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. Select the schema and enter the table name. Choose the option Connect To Semantic Model. Enter the workspace and name of the semantic model to connect to the required semantic model and get the data. 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. You can also schedule refreshes for a periodic data source refresh and ensure that your data is in sync with your semantic model.