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.
Select your Connection and the required Semantic Model.
Select Next.
Capacity workspaces with Pro licenses are not supported. Make sure to select a workspace of premium capacity.
Map and assign your data to the table by selecting the required fields and corresponding values.
Set the primary key fields by selecting the three dots and selecting primary keys.
If needed, you can use filters to include only specific field values from the table.
Select Next.
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.
Review the detected column settings.
If the primary key is unselected, select the appropriate column as the primary key.
Configure columns as required:
Mark fields as Mandatory if they must contain values.
Set fields with distinct values as Unique Key to allow only unique values.
Set a column as an Identity Column when you need PowerTable to generate unique, sequential values automatically. Only numeric columns and primary key columns can be configured as identity columns.
Modify column properties, including:
Length
Data type
Input type
Display name
Enter default values for columns, if required.
Optionally, select Add Column to create additional columns.
To create a composite primary key, select Unique Combination, and then select two or more columns to define a unique combination key.
Select Finish.
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.
The table app is created successfully in PowerTable with the configured columns and values. Select Save to save your table.
