Forum Discussion
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 ...
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.
