Writeback Functionality In Power BI

[bharathi2233]

Hi,

I have a stored procedure in the database which will be inserting or updating the data if we invoke it by sending a key. Now I have to send this key and invoke the stored procedure from Power BI. how to do this? Do I have to use the Writeback? or do we have any other options?

Thanks in Advance.

[cengizhanarslan]

Option 1) Put an API layer in front of the stored procedure:

Power BI triggers an action → that action calls an HTTP endpoint → the endpoint runs the stored procedure and returns success/failure.

Typical implementations:

• Power Automate button in the report → calls an API / SQL connector → runs the SP.

• Power Apps visual → user submits the “key” → Power Apps calls SQL / API → runs the SP

Option 2) Translytical Task Flows (write-back/actions):

If your write-back can be implemented through Fabric user data functions (or you can expose your SP via an API that the function calls), you can put a “data function button” in the report that passes inputs (like your key) and triggers an action.

[v-aatheeque]

Hi @bharathi2233 

Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.

[Kedar_Pande]

@bharathi2233 

Power BI button → Power Automate flow → Execute SQL stored proc

[rohit1991]

Hii @bharathi2233 

Power BI does not support direct writeback or executing insert/update stored procedures from a report, as it is a read-only analytics tool. To send a key and invoke a stored procedure, you must use an external layer such as a Power Apps visual (for data entry/updates) or a Power Automate flow (button-based action) that receives the key from Power BI and executes the stored procedure via the SQL connector or an API.