Translytical Task Flows in Power BI: Update Data in Reports

Until now, Power BI has primarily been a read-only analytics tool, pulling data into reports so users can analyze insights and make decisions. But with the introduction of Translytical Task Flows in Power BI, this is about to change.

Translytical Task Flows allow users to not only consume data but also write back to the underlying dataset directly from a Power BI report. Imagine being able to update prices, add comments, or even call APIs,all without needing a data engineer. This new functionality truly changes how we manage and interact with business data.

What Are Power BI Translytical Task Flows?

Translytical Task Flows enable real-time interaction with data directly inside Power BI. Instead of relying solely on data engineers or separate systems, report users can:

• Update existing records
• Insert new records
• Delete records
• Trigger API calls

This brings transaction-like functionality into an analytics environment, bridging the gap between databases and BI tools.

Getting Started: Enabling Features in Microsoft Fabric

To use Translytical Task Flows, you need to configure a few settings in Microsoft Fabric:

1. Enable in the Admin Portal
   • Turn on SQL database and User Data Functions.
2. Create a Workspace
   • You can use an existing one or start fresh.
3. Load Sample Data
   • For this demo, Marthe uses the AdventureWorks Sales data, specifically the Product table containing product IDs, names, and list prices.

Setting Up a SQL Database

Since Translytical flows involve heavy read-write operations, a SQL database is ideal.
Steps:

1. Create a new SQL database.
2. Load sample AdventureWorks data.
3. Confirm the tables (SalesLT.Product in this example).

Now you’re ready to define a user-defined function to control updates.

Creating a User-Defined Function

A user-defined function (UDF) lets you define what happens when users submit changes.

• Connect the function to your SQL database.
• Define logic for update, insert, or delete operations.
• Example function: update_list_price(ProductID, ListPrice)

This ensures that when a user updates a value in Power BI, the function pushes the change back to SQL.

Building the Power BI Report

Inside Power BI Desktop, follow these steps:

1. Enable Preview Features
   • Translytical Task Flows
   • Connect to Fabric SQL Databases
   • Text Slicer Visual
2. Connect to SQL Database
   • Choose DirectQuery (not Import) to enable live updates.
3. Build the Report UI
   • Table visual: ProductID, Name, ListPrice
   • Text Slicer: for entering a new list price
   • Button: configured with “Data Function” → update_list_price

When a user selects a product and updates the price, clicking the button pushes the change to the SQL database in real time.

Example in Action

• Selected ProductID: 877
• Original List Price: $6.99
• New List Price entered: $7.99

After clicking the update button, the SQL table immediately reflects the change,confirming the write-back operation worked.

Why This Matters

This feature opens the door to collaborative, actionable BI:

• Managers can comment on KPIs directly in Power BI.
• Teams can update datasets without waiting for IT.
• Business workflows become more interactive.

In the age of AI, pairing this with Copilot could lead to even more powerful, automated insights.

Conclusion

Power BI Translytical Task Flows transform reports from passive dashboards into interactive business applications. By enabling data write-back, organizations can:

• Streamline workflows
• Empower business users
• Enhance collaboration between teams

If you want to explore more advanced Power BI features, check out Data Bear’s Power BI Training to level up your skills.