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