Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
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

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…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,077 Most Valuable Professional

Leaderboard
Loading started