Integrating PowerBI, Power Automate to write back data on to SQL server.

[sruthi_g]

Hi everyone,

I'm trying to make a PowerBI dashboard for my organization's internal data validation. We have a PowerBI report with a table in a matrix form. Each row in this table has  different numbers but multiple levels of hierarchy. What I want to achieve is that on clicking a row in this table- there are options for Valid,Invalid and a textbox to add comments if necessary. The values that were clicked-wither Valid or Invalid and the comments in the textbox, need to be written back to SQL Server -which is the data source. Now, the PowerBI part is ready. And I used PowerApps for the write back, but my senior manager wants us to bypass the PowerApps part since the edit form is taking a lot of time to load, and use PowerAutomate instead. I've never used PowerAutomate earlier so can anyone suggest me links/resources for this use case? Even ways to make PowerApps load the form faster would be great. Thanks!

[Ritaf1983 · Accepted solution]

Hi @sruthi_g 
I recommend to consult about the issue in the power automate community :
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

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