Forum Discussion
Warehouse Table writeback supported from PowerApps?
Hi,
I am following documented scenario and trying to create a table with primary key in Fabric DataWarehouse, but looks like even provided sample did not work here.
HimanshuS-msft can you help please? Thanks.
source: Primary, foreign, and unique keys - Microsoft Fabric | Microsoft Learn
Greetings Anonymous! This is a recently discoverd issue that we are working on resolving. If you run the statements seperately they work. The issue happens when you try to run them at the same time.
Thanks KevinConanMSFT it was very helpful for as right now.
charrington thanks for your time and investigaton. What I am trying to achieve is only to build star schema above Lakehouse (silver) data in Warehouse (Gold) layer.
As using SCD2 for dimensions, I want to create surrogate key there and not to use Id from source system.
Anonymous Welcome!
You might wanna look also at this thread in case you haven't come across it, discussing identity fields. The Guid trick might help or not in your case, not sure.
