Save DeltaSet
Saves all changes in a DeltaSet to an Azure SQL or SQL Server table.
A typical use case for this action is to save the changes made by users in the Writeback Table or Writeback Comments visuals for Power BI. This action will save all changes made by the user in Power BI by either inserting, updating, or deleting rows in the SQL Server / Azure SQL target table.
Properties
| Name | Type | Description |
|---|---|---|
| Title | Optional | A descriptive title of the action. |
| Connection | Required | The SQL Server Connection. |
| Dynamic connection | Optional | Use this option of you needs to use a connection from the Create Connection action. |
| DeltaSet | Required | The DeltaSet to save to the target table. |
| Target table | Required | The name of the table where data will be stored. If this differs from the table the data is read from in the Power BI model, ensure the target table has columns with matching names and data types as defined in the column definitions of the Writeback Table visual. |
| Save data options | Optional | For advanced scenarios (see below), use this option to override the default behavior for applying DeltaSet changes. |
| Command timeout | Optional | The time limit in seconds for command execution before it times out. Default is 120 seconds. |
Save data options
By default, the columns or fields you have defined as keys in the Power BI visual(s) will be used to determine which rows to update, delete or insert. This information is contained in the DeltaSet. For example, if you have used DepartmentID and Period as key columns in the Power BI Comments visual, Flow will match on the DepartmentID and Period column in the target table to determine whether or not to do an update, insert or delete on that dimensionalitity. If, for some reason, you want to override which columns are used as qualifiers to save changes, you can use the Save data options configuration to handle this.
| Property | Description |
|---|---|
| Column name | The name of the column that you want to specify a behavior for. |
| Use as update or delete key | By enabling this option, Flow will match by this column when updating or deleting rows instead of using the columns defined as keys in the DeltaCells. |
| Allow updating data in this column | You can set this option to false to explicitly prevent this column from being updated, even though the DeltaSet contains changes for the column. |
| Enable identity insert | Enable this option if you need to enable inserting data to an identity column. In most databases, if you try to insert data to an identity column, the operation will fail unless explicitly enabled. |
SQL Server: Videos / Getting started
This section contains videos to help you get started quickly working with Azure SQL / SQL Server using Flow.
Dump CSV file from Azure Blob container to Azure SQL table
This video demonstrates how to import all records from a CSV file into an Azure SQL table.
In the demo, no data import options (such as data type conversion, number or date formatting) are specified, meaning the data is imported as raw text.