Skip to main content

    Data Warehouse

    Needs Votes

    Fabric Warehouse table support for Primary Key enforced

    Vote (79) Share
    Christian Harrington's profile image

    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 (2)
    Christian Harrington's profile image Profile Picture

    Thomas Munson on 15 Sep 2024 17:24:33

    RE: Fabric Warehouse table support for Primary Key enforced

    This would be a great help to us in developing apps that we need to leverage the power of MS Fabric.

    Christian Harrington's profile image Profile Picture

    Mike Forbes on 15 Mar 2024 14:17:46

    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.