# Connect PowerTable sheet to a semantic model

In this article, you look at the steps to connect to a semantic model from a PowerTable sheet. Connect to an existing semantic model and create a table app. The data table, along with any changes or updates, is saved to your preferred destination database.

{% hint style="info" %}

#### Important

This feature is in preview.
{% endhint %}

{% hint style="info" %}

#### Note

You can also create a table by uploading data from an Excel or CSV file. For more information, see [Create a table app with PowerTable sheets.](/powertable-sheets/how-tos/create-a-table-app-with-powertable-sheets.md)
{% endhint %}

### Prerequisites

Before you begin, make sure that you have the following prerequisites in place:

* Connections established to the [Fabric SQL database](/planning-sheets/how-tos/create-a-database-connection.md) and [semantic model](/planning-sheets/how-tos/create-and-share-a-cloud-connection-for-a-semantic-model-sp.md) that contain the data for your PowerTable.
* A [Plan item](/planning-sheets/how-tos/creating-a-planning-sheet.md#create-a-planning-sheet) created in your Fabric workspace.

### Create a PowerTable sheet

1. In your plan, select **New PowerTable Sheet** or select the **PowerTable** icon on the landing page. Enter a name for the sheet and select **Create**.

<figure><img src="/files/eKstloELI9AkCmG2O5M4" alt=""><figcaption></figcaption></figure>

2. Select **Create a New App** to create your app. You can also select **Explore PowerTable** to experience a sample PowerTable app.

<figure><img src="/files/x2BbGyKrkRsLeaaqCD6h" alt=""><figcaption></figcaption></figure>

3. **Select a Connection:** Choose a Fabric SQL connection. You can also create a new connection if required.

<figure><img src="/files/GY65wbmJa1Vt481E4rgw" alt="" width="375"><figcaption></figcaption></figure>

4. **Database Name:** Select the Fabric SQL database. The metadata for your app is stored here. Select **Add**.

<figure><img src="/files/4OX87hA6Fb8xjPLK9WW5" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}

#### Note

When a new Plan item is created in a workspace, a Fabric SQL database is automatically created for that workspace. This database stores all the plan app metadata for workspace users. You can choose this database.
{% endhint %}

5. Select **Connect**.

<figure><img src="/files/2aUdAexmfc6Oap7v8bzP" alt="" width="375"><figcaption></figcaption></figure>

### Create a table

1. Select **New Table**.
2. Choose the database schema.
3. Enter a **Table Name**.
4. Choose **Connect To Semantic Model** in **Import Data**.
5. Select your **Connection** and the required **Semantic Model**.
6. Select **Next**.

<figure><img src="/files/1B24hije5JDz3PV1un7m" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}

#### Note

Capacity workspaces with Pro licenses are not supported. Make sure to select a workspace of premium capacity.
{% endhint %}

7. Map and assign your data to the table by selecting the required fields and corresponding values.

<figure><img src="/files/vXhnpPjSfLDU5upYxSsm" alt=""><figcaption></figcaption></figure>

8. Set the primary key fields by selecting the three dots and selecting primary keys.

<figure><img src="/files/NON8TOeXAiXm69bmli6T" alt=""><figcaption></figcaption></figure>

9. If needed, you can use filters to include only specific field values from the table.

<figure><img src="/files/RV47jVtFFO9bePy5I5DH" alt=""><figcaption></figcaption></figure>

10. Select **Next**.

<figure><img src="/files/7FzmghQgryr4szJ8xAbJ" alt=""><figcaption></figcaption></figure>

#### Configure columns

PowerTable sheets automatically detect column properties and rename any unsupported column names to match the supported format. You can review and modify them as needed.

1. Review the detected column settings.
2. Select the **primary key** if unselected.
3. Modify column properties, such as the data type, input type, and display name.
4. Enter default values wherever required.
5. Optionally, add columns using **Add column**.
6. Select **Finish**.

{% hint style="info" %}

#### Note

In this step, you can **enable Slowly Changing Dimensions (SCDs)** by turning the toggle. For a table, this is a one-time configuration that cannot be modified later.
{% endhint %}

<figure><img src="/files/htLSbK7nYwybuJ97l4su" alt=""><figcaption></figcaption></figure>

7. The table app is created successfully in PowerTable with the configured columns and values. Select **Save** to save your table.

<figure><img src="/files/sDNGAJiRW8KvmvrVWOpg" alt=""><figcaption></figcaption></figure>

### Next steps <a href="#next-steps" id="next-steps"></a>

Configure [access control](/powertable-sheets/how-tos/set-up-row-and-column-access-control.md) and automated workflows and [approvals](/powertable-sheets/how-tos/approval-flow/configure-approval-workflow.md) for your new app.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.fabricplan.com/powertable-sheets/how-tos/connect-powertable-sheet-to-a-semantic-model.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.