Need to writeback to Azure SQL database

[Vivek26]

Hi All ,

We are exploring writing back to Azure SQL database from PowerBI.

From what I noticied , Translytical flows can't write to SQL database  hosted in Azure(atleast easily).

We need near realtime updates , Can you please suggest what are our choices ?

Power Apps ? 

Power Automate ?

A combination of both?

Also can you please guide us on the licensing requirements for the same ?

We really appreciate your help and inputs

[Vivek26 · Accepted solution]

Thanks to All for your time , We really appreciate it. For now we have opted for SQL database inside fabric and we are going to use translytical task flows

[v-lgarikapat]

Hi @Vivek26 ,

I just wanted to check if your issue has been resolved. If you still have any questions or need help, feel free to reach out I’m happy to assist.

Thank you for being an active part of the community. Looking forward to hearing from you!

Best regards,
Lakshmi

[v-lgarikapat]

Hi @Vivek26 ,

Thanks for the update! Using the SQL database in Fabric with translytical task flows sounds like a great plan. Let us know if you need any help along the way.

Best Regards,

Lakshmi.

[v-lgarikapat]

Hi @Vivek26 ,

Thanks for reaching out to the Microsoft fabric community forum.

@rohit1991 ,

@Ritaf1983 

Thanks for your prompt response

In addition to  @rohit1991  and @ @Ritaf1983 , I have included the relevant learning documents which can help you understand and resolve the issue.

Access data in SQL Server - Power Apps | Microsoft Learn

Connect to SQL Server from Power Apps overview - Power Apps | Microsoft Learn

Official Microsoft Power Automate documentation - Power Automate | Microsoft Learn

If you are still facing any challenges, please don't hesitate to reach out. We are happy to assist you further.

Thank you for your continued engagement and for being an active member of the community.

Best regards,
LakshmiNarayana

[v-lgarikapat]

Hi @Vivek26 ,

I wanted to follow up and confirm whether you’ve had the opportunity to review the information we provided. If you have any questions or need further clarification, please don’t hesitate to reach out.

Best Regards,

Lakshmi.

[v-lgarikapat]

Hi @Vivek26 ,

I wanted to follow up and confirm whether you’ve had the opportunity to review the information we provided. If you have any questions or need further clarification, please don’t hesitate to reach out.

Best Regards,

Lakshmi.

[rohit1991]

Hi @Vivek26 ,
Power BI cannot write back directly to Azure SQL, but you can enable writeback by embedding a Power Apps visual in your report. Users can update or add data through Power Apps, which writes changes instantly to Azure SQL. If you need more complex workflows, you can connect Power Apps to Power Automate to trigger flows that update your database. Both solutions require Power Apps and/or Power Automate licenses (per-app or per-user). For most scenarios, Power Apps embedded in Power BI is the simplest and most real-time option.
Power Apps Pricing | Power Automate Pricing

[Ritaf1983]

Hi @Vivek26 
Please refer to the linked video guides about using power apps :

https://www.youtube.com/watch?v=FwgNQ-tOetY
https://www.youtube.com/watch?v=8Spa1pqOol4
And Native option for Fabric Capacity
https://www.youtube.com/watch?v=CUQRoR0yz8g

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.