Native Write-Back with Translytical Task Flows in Power BI

For years, "write-back" has been the holy grail of Power BI development. Until recently, if you wanted users to update a status, add a comment, or adjust a forecast directly within a report, you had to rely on complex Power Apps integrations or external third-party tools. 

With the introduction of Translytical Task Flows in Microsoft Fabric, that barrier is finally disappearing. This feature merges "transactional" and "analytical" workloads, allowing users to not only see data but act on it instantly without leaving the Power BI interface. 

What are Translytical Task Flows? 

At its core, a Translytical Task Flow is a bridge between a Power BI visual (like a button) and a Fabric User Data Function. 

When a user clicks a button in the report, it triggers a Python script (the UDF) hosted in Microsoft Fabric. This script can receive parameters from your report, such as a selected ID or a comment typed into a slicer and perform operations like updating a database. 

How to implement Write-Back Flow 

1.Create the SQL Database 

For an optimal write-back flow, a Fabric SQL Database is the best choice. It provides the low-latency, row-level transaction speed required for a seamless user experience. 

1. Create a new SQL Database in your Fabric workspace. 

2. Create a target table (e.g., WriteBackTable) to store your data. 

   
   

2.Create the User Data Function (UDF) 

The UDF is the "brain" of the operation. It’s a Python-based function that executes your database commands. 

1. In your workspace, select New Item > User Defined Function. 

2. Under the Manage Connections tab, map your Fabric SQL Database. This allows the script to use fabric_sql_connection to execute UPDATE or INSERT queries. 

3. In the editor, use the @udf.function decorator to define your inputs (in this case, RecordID and ProductPrice). 

   
   

3.Configure Power BI Report 

Open Power BI Desktop. Ensure you are using the latest version, as this feature relies on specific preview toggles. 

1. Connect to Data: Select OneLake Catalog > SQL Databases and choose your database. Select Connect to SQL Endpoint and use DirectQuery to ensure changes are reflected instantly in the report. 

2. Build the UI: 

   1. Create a Table Visual containing RecordID, ProductName, and ProductPrice. 

   2. Add a Text Slicer and title it "New Price Input". 

   3. Add a Button which will serve as the trigger for your write-back action. 

3. Configure the Action Button: 

   1. Go to the Format pane > Action. 

   2. Set the type to Data function and click the fx icon to select your Fabric UDF.

   3. Map the Parameters: For RecordID, click the fx button next to the input and bind it to the RecordID column. For ProductPrice, select the "New Price Input" value from the dropdown to link your slicer to the UDF parameter. 

      
      

4.Test the write back  

With the setup complete, you can now test the live loop: 

1. Select a specific product row in your table visual. 

2. Enter a new value in the text slicer. 

3. Click the Submit button. 

The price for the selected row will be updated instantly in both the Fabric SQL Database and the Power BI visual.