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

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.  

      • charrington's avatar
        charrington
        Advocate V
        3 years ago

        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.

  • charrington's avatar
    charrington
    Advocate V
    3 years ago

    Hi Anonymous 
    I just tried and got the same error as you...weird...I am 100% sure it was working when I posted the issue.

    It looks they are doing a lot of changes...they will probably fix it at some point.

    But anyway the Primary key is not very useful right now in Fabric. You cannot enforce it. So it's more for performance only. Not sure what you wanted to acheive with this. It's not meant for transactional data, at least for now.

    Thanks