Christian Harrington on 19 Jun 2023 16:30:26
Warehouse tables don't support Primary Key enforced right now.
With this limitation we cannot use apps writing to the database using a primary key.
The scenario we are trying to use is PowerApps writing to Fabric Warehouse.
But there could be many others, any scenario requiring a primary key for now would no work.
Please add some Operational Data Store table type supporting primary key.
Original post/quesiton is here (some more details are provided:
https://community.fabric.microsoft.com/t5/General-Discussion/Warehouse-Table-writeback-supported-from-PowerApps/m-p/3284207#M303
Thanks
Christian
- Comments (1)
RE: Fabric Warehouse table support for Primary Key enforced
Enforceable Primary Keys, Foreign Keys & Unique Constraints are critical to be able to rely on the underlying data. Without these all one can do is hope that data integrity is maintained by ETL processes.