Skip to main content

Notifications

Community site session details

Community site session details

Session Id : zAnKNXKgQ7mDH3ILzOmtyh
Power Apps - Building Power Apps
Unanswered

Write back to Synapse using PowerApps

Like (0) ShareShare
ReportReport
Posted on 2 Mar 2021 10:50:26 by 3

Hi,

I'm working on a POC that aims to intergrate Power BI with Power Apps and Azure Synapse. Basically the goal is to use Synapse as source data for PBI and integrate a PA application to write back to Synapse, if an end user needs to fix some problems on the DB for ex.

In another post (https://powerusers.microsoft.com/t5/Building-Power-Apps/Power-Apps-canvas-app-with-Azure-Synapse-as-data-source-Not-able/td-p/573288) I found that "Today, Azure SQL Data Warehouse connector allows you to connect to Azure Synapse and run SQL queries, stored procedures to perform CRUD (create, retrieve, update and delete). But the catch is, it is available only in Power Automate and not available in Power Apps. So, if you need to create an app against Azure Synapse you will have to call flow from apps to perform CRUD actions.".

Does anyone know more details about this integration with Power Automate? Is it still feasible to use Power Apps, maybe using Power Automate as a "bridge" between PBI, Power Apps and Synapse?

Thanks,

A.

 

  • RituNegi Profile Picture
    2 on 30 Jul 2022 at 05:24:45
    Re: Write back to Synapse using PowerApps

    Please refer to the blog using power automate as bridge to write back in synapse in detail:

     

    https://www.accelerant.com/post/power-automate-as-bridge-to-write-back-on-synapse-using-power-apps

  • StalinPonnusamy Profile Picture
    Super User 2024 Season 1 on 25 Jun 2021 at 16:49:58
    Re: Write back to Synapse using PowerApps

    There is no connector to Synapse, so we can’t directly connect from PowerApps. But we came up with workaround to have Azure SQL in the middle to solve this requirement.

     

    Please refer this blog for details.

     

     

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

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

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 250 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 122

#3
stampcoin Profile Picture

stampcoin 108

Overall leaderboard
Loading started
Loading complete