Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Suggested answer

Updating Data in Fabric Warehouse using SQL Server Endpoint via PowerApps

Like (1) ShareShare
ReportReport
Posted on 3 Sep 2024 07:32:53 by 2
Hi,
I am working on a proof of concept (POC) to integrate PowerApps with the Fabric Warehouse SQL endpoint. My client’s requirement is to update data in Fabric Warehouse tables using a SQL Server endpoint from PowerApps with a SQL Server connector.
Previously, I accomplished this using Power Automate to write a SQL query in a Power Automate action, and it worked successfully. However, the current requirement is to update the data directly using PowerApps. When I attempt to update the data from PowerApps using the Patch function, I encounter the following error: “The data source is either read-only or has no primary key, so the Patch function cannot write to it.”
Is there any way to achieve this? According to some blogs I read, “PowerApps can only write to tables with an enforced primary key.” It seems this is not possible with the current T-SQL layer in the Fabric Data Warehouse.

Could you please provide any ideas or solutions to address this issue?
 
Thanks!
  • Suggested answer
    Michael E. Gernaey Profile Picture
    42,048 Super User 2025 Season 1 on 04 Sep 2024 at 05:13:01
    Updating Data in Fabric Warehouse using SQL Server Endpoint via PowerApps
    Hi
     
    Is there any reason you are not allowed to add a Primary Key to the data? You can of course technically, but is there any one blocking you from asking for it?

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

🌸 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…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 98 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 73

#3
stampcoin Profile Picture

stampcoin 48

Overall leaderboard