Configure writeback destinations

You can set up Writeback destinations for databases, data warehouses, data lakes, files, and webhook URLs. Use writeback destinations to save data using Writeback and load it to the Writeback table in the target system.

Plan supports the following destination type:

• Fabric SQL

Go to Writeback > Settings > Destination > Add Destination to view and configure available destinations.

Add destination

Before you start writeback, add one or more destinations where your data table will be exported.

Create a new connection

In the Create Destination dialog, select + New next to Select a Connection to create a new connection, or choose dropdown to select an existing connection.

Configure the destination

After selecting the connection, provide the required details:

• Database Name: Select the target database.

  • Select the destination database: In the Select destination database dialog, browse and select the required database from the OneLake catalog.

  • For example, select My_Planning_DB from the list of available databases.

Generic destination settings

1. Configure column settings

You can define how numeric and text data is written back to the destination.

• Set decimal precision

  • Use Decimal Precision to define the number of digits after the decimal point for numeric values. This setting applies to all destinations in the report.

Plan supports up to 10 decimal digits. Values are rounded based on the configured precision during writeback.

When you apply the decimal precision shown in the image above, Plan writes back values (in this example, to Fabric SQL) rounded off to 5 decimal places.

• Set text length

  • Use Text Length to control the maximum number of characters written back for text fields. By default, the limit is 512 characters, or you can allow the maximum supported by the destination.