Forum Discussion

charrington's avatar
charrington
Advocate V
3 years ago

Warehouse Table writeback supported from PowerApps?

Hi, We tried a scenario to use PowerApps to write data to Fabric Warehouse, in order to keep all our data into Fabric. We know we can store this data somewhere else like Dataverse, etc.  but still ...
Data Integration
data warehouse
KevinConanMSFT's avatar
KevinConanMSFT
Microsoft Employee
3 years ago

At this time, Primary Key, Unique Key and Foreign Key can only be added with the ALTER TABLE command.  I apologize for the inconvience!

charrington's avatar
charrington
Advocate V
3 years ago

Thanks for the reply.

But even with ALTER TABLE, we are not able to add a Primary key enforced. We are able to alter the table to add Primary key NOT ENFORCED only. But this is useless in the described scenario, with PowerApps, which requires a "true" Primary key.