Connect to Semantic Model

In this article, you'll look at the steps to connect to a semantic model from PowerTable.

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.

You can 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.

Prerequisites

• A Fabric SQL database to store your app's metadata.

• DMT connections to the Fabric SQL database and semantic model.

• A Plan item in your Fabric workspace.

Create a PowerTable Sheet

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

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 DMT Connection to Fabric SQL database

When creating a new app, you need to select a DMT connection to connect to a Fabric SQL database. Select a connection and click Connect.

Then, select a Fabric SQL database. The metadata for your app is stored here. Click Add.

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 DMTS Connection and the required Semantic Model.

6. Click Next.