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!

Report
All responses (
Answers (