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.

[bharathi2233]

Thanks everyone for your input. I will check the options and try it out and update you.

[v-aatheeque]

Hi @bharathi2233 

Checking in to see if you had a chance to review or test the recommendations shared earlier.
If the issue is still unresolved, please share what you’ve tried so far or any blockers you’re facing, and we can assist you further.

[cengizhanarslan · Accepted solution]

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.