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.
please provide any ideas or solutions to address this issue.
Posting in multiple forms the same thing we really like to avoid, as it causes lots of unanswered questions.
I answered you on the other thread
Was this reply helpful?YesNo
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.
154
Share
Report
All responses (
Answers (
