> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/configure-advanced-settings.md).

# Configure advanced settings

Under **Advanced settings**, you can control validation rules, and rename writeback columns. These options help you manage what data gets written back and how it is stored in the destination.

### 1. Validate writeback columns

In the **Advanced** tab, you can enforce validation rules on data before it is written back. You can use a null check or a formula-based condition.

<figure><img src="/files/Bh4n1ZApRL4d1b6ZLA1T" alt=""><figcaption></figcaption></figure>

**1.1. Cannot be empty**

Use **Cannot be empty** to write back only the cells that are not null for the selected field.

<figure><img src="/files/B0Afsj7Qnx9Tnh0PsE3J" alt=""><figcaption></figcaption></figure>

**1.2. Enter formula**

Use **Enter formula** to define a formula that must evaluate to true for cells to be written back. Cells that do not meet the validation rule are excluded during writeback.

You can also apply cross-filters. During writeback, the system shows a preview of excluded cells.

<figure><img src="/files/lWu9UMKD37ebiDENabc4" alt=""><figcaption></figcaption></figure>

**1.3. Prevent writeback when validation fails**

Turn on **Prevent writeback when validation fails** to stop writeback when empty fields are detected. When validation fails, the system generates an exception notification with details about the empty measures, columns, or rows that do not meet the validation condition.

<figure><img src="/files/iHyUDbPqBbfM2pgj1y49" alt=""><figcaption></figcaption></figure>

### 2. Rename writeback columns

You do not need to use the source dataset column names during writeback. You can specify a custom column name for the writeback table.

To rename columns, go to **Writeback settings > Advanced** and select **Writeback column rename**.

<figure><img src="/files/oy68S7lguZU9g0t1oYXL" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Use standard database naming conventions, such as `snake_case` or `PascalCase`, to ensure compatibility with your destination database.
{% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.fabricplan.com/documentation/plan/planning-sheets/how-tos/persist-planning-data-using-writeback/configure-advanced-settings.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
