A plan rarely stops when the numbers are submitted. With writeback event triggers, a writeback can refresh reports, feed downstream systems and alert the right people, configured from the planning UI with no code. The loop from plan to action closes entirely within Fabric.
Writeback Event Triggers at a Glance

In this article:
Why It Matters
Before Event Triggers, the steps after a writeback were manual or needed external plumbing: someone refreshed the report, re-ran a pipeline or called an API from an Azure Function. Now the plan starts that work itself, the moment the data lands, using the Fabric items your data team already runs.
The result: reports show approved numbers within minutes, downstream systems get the plan without a hand-off, and failures reach someone who can fix them.
Events and the Actions They Can Run
| When a writeback… | Typical actions | Example |
|---|---|---|
| Starts | Stored procedure, Teams or Outlook notification | Snapshot the current destination table before it changes, or tell data owners a load is under way |
| Succeeds | Semantic model refresh, pipeline, notebook, Dataflow Gen2, stored procedure, notification | Refresh the variance report, push the approved budget to the ERP, or recalculate a downstream allocation |
| Fails | Teams or Outlook notification, stored procedure | Alert the plan administrator with the error details and log the failed run |
You can configure several triggers on one planning sheet, so different automation paths run for different events, and run actions in sequence, such as a stored procedure followed by a semantic model refresh.
Watch It Work
Demo, about 3 minutes: set up a trigger that runs a pipeline after a successful writeback, pass the execution ID as a parameter, chain a stored procedure with a semantic model refresh, and check each run in the trigger logs. Also on the Fabric Plan community.
Four Recipes to Start With
Each one replaces a manual step that usually follows a planning cycle.
1. Close the Loop to Reports
On succeeds, refresh the semantic model that holds plan versus actuals, so the variance report shows the new plan without waiting for the next scheduled refresh. See it end to end in Planning Decision to Business Action.
2. Feed the Approved Budget Downstream
Once the plan clears approvals and is written back, run a Fabric pipeline on succeeds that copies the approved version to the ERP or a finance data mart, passing the scenario and version as parameters.
3. Recalculate Dependent Data
On succeeds, run a stored procedure or notebook that rebuilds allocations, aggregates or derived tables that depend on the plan, then refresh the semantic model that reports on them.
4. Never Miss a Failure
On fails, send a Teams or Outlook message to the plan administrator with the writeback details, so issues are fixed before the deadline.
Set Up Writeback Event Triggers
Event Triggers are configured on the planning sheet, after a writeback destination exists.
Step 1: Configure the Writeback Destination
Set up writeback to Fabric SQL or OneLake for the planning sheet. See writeback to OneLake and the Planning 103 – Writeback video.
Step 2: Add an Event Trigger
From the planning UI, add a trigger and choose the event: when the writeback starts, succeeds or fails.
Step 3: Choose the Action
Pick the Fabric item to run and its connection, such as a pipeline, notebook, Dataflow Gen2, semantic model refresh or stored procedure, or a Teams or Outlook notification.
Step 4: Map Parameters
Pass writeback details and execution metadata, such as the execution ID, to the action, so it processes only what changed.
Step 5: Test with a Dry Run
Run a writeback on a test version and confirm each action ran in the trigger logs, then add more triggers for other paths.
PowerTable too. PowerTable Automations can run stored procedures from a Fabric SQL database, passing values from the record that triggered them, alongside no-code create, update and find-record actions. Watch Execute Stored Procedure Action in PowerTable Automations and Setting Up Automations in PowerTable.
Good Practices
- Make actions safe to re-run. A writeback may run more than once in a cycle. Design procedures and pipelines so a second run gives the same result.
- Always add a failure path. Pair every success automation with a failure notification to someone who can act on it, and check the trigger logs after the first few cycles.
- Pass parameters, don’t hard-code. Use the writeback details to target the right scenario, version or table, so one action serves many sheets.
- Refresh only what changed. Refresh the tables the plan touched rather than a whole large model, to save time and capacity.
- Know where the cost lands. Event Triggers don’t use Fabric Plan automation jobs. Each item a trigger runs, such as a pipeline, notebook, Dataflow Gen2, semantic model refresh or stored procedure, consumes capacity under its own Fabric workload, just as it would if you ran it yourself. Fabric Plan’s background jobs, at 2 CU-hours per completed job, apply only to connected planning with automatic updates between two or more sheets, and PowerTable automations that cascade updates across two or more tables. See how pricing works.
- Keep ownership clear. Document who owns each triggered item, so changes to a pipeline don’t silently break the plan.
Learn More on the Community
- Trigger Fabric Actions After Writeback in Fabric Plan (video, about 3 minutes)
- Planning Decision to Business Action in Fabric Plan (video): publish to Power BI and Fabric IQ, then start downstream work
- Planning 103 – Writeback (video): writeback basics
- Approvals and Workflows in Fabric Plan (blog): what happens before the approved writeback
- Execute Stored Procedure Action in PowerTable Automations (video, about 3 minutes)
- Connect the Plans (blog): how approved plans feed reports, AI and actions across teams
Automate the Step Your Team Does by Hand
Pick the one task that always follows a writeback today, usually a report refresh, and make it an Event Trigger. Add the failure alert at the same time.
Sources
- Event Triggers: What’s New in Fabric Planning, FabCon Europe 2026 Updates
- Trigger Fabric Actions After Writeback in Fabric Plan (Fabric Plan community)
- Set up writeback to persist data (Microsoft Learn)
- Semantic model refresh activity (Microsoft Learn)
- Fabric Plan capacity pricing (Lumel)
Feature details reflect published Fabric Plan updates at the time of writing.

Comments
0Please log in to comment.