Table of Contents

Writeback Comments trigger

The trigger defines the starting point of a Flow that stores comments from the Writeback Comments Power BI visual.

To create a Flow that saves comments from the Writeback Comments visual, add this trigger. It starts the Flow when the user presses the Save button in the Writeback Comments visual, and outputs a DeltaSet containing the change made by the user. You then need to add an action for the specific target system that you want to save the comments to, for example SQL Server / Azure SQL, PostgreSQL or Snowflake.

img

Properties

Name Type Description
Test data Optional Use this property to define test data to save to a database, file or service. The test data is only used when you run the Flow manually from the Designer during development. The test data is NOT used when data is saved from the Power BI user interface. See below for a description of the required format.

Returns

The trigger returns a DeltaSet containing the comments to save to a database, file, or service.
The DeltaSet can be passed to an action that saves the changes to a database, file or service.

The following actions currently supports saving DeltaSet changes:


Test data format

This describes the format you can use to test saving changes from the Writeback Table before you have added it to a page in Power BI. To manually run a Flow for testing purposes, press the Run button in the Flow Designer application toolbar.

{    
    "column": "columnName",
    "value": "string",
    "context": {"column1": "value1", "column2": "value2"}    
}

Example - Test data

The example below shows a test data JSON object that describes changes to January and February amounts of how much a sales representative is expected to sell for a specific product.

{    
    "column": "Comments",
    "value": "This is my comment.",
    "context": {"ProductId": "100", "SalesRepId": "56-08-12"}
}
Edit this page