Skip to main content

Notifications

Community site session details

Community site session details

Session Id : uuJzi7FJho/Kv+DpAypDie
Power Automate - Using Flows
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 11 Feb 2024 12:41:48 by 14

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!

  • lbendlin Profile Picture
    7,818 Super User 2025 Season 1 on 11 Feb 2024 at 23:54:25
    Re: Integrating PowerBI, Power Automate to write back data on to SQL server.

    Your best bet is to make the PowerApp faster.  While you can theoretically use PowerAutomate for the write back there is absolutely no feedback that the action was successful.  With PowerApp and a DirectQuery connection to the SQL Server you can at least get a semblance of a real time feedback (in the sub-10 second range)

     

    NOTE:  Both these options are hampered by the fact that ALL your users need PowerApps or Power Automate Premium licenses.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Using Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 7 Super User 2025 Season 1

#1
rzaneti Profile Picture

rzaneti 7 Super User 2025 Season 1

#3
CU20032117-0 Profile Picture

CU20032117-0 4

Overall leaderboard

Featured topics

Restore a deleted flow
Loading started