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
HimanshuS-msft's avatar
HimanshuS-msft
Microsoft Employee
3 years ago

Hello charrington,

 Thanks for using the Fabric community . I think the issue which you are facing is that  power apps wants you to have a primary and in warehouse  PRIMARY KEY is only supported when NONCLUSTERED . Let me know if this is not correct .

Since warehouse supported Massively parallel processing so having a primary does slows down the data load process . Can I request you to post the idea here ?

Since in your case the end goal is to get the data in Fabric , have you explored the option to write to the lakehouse in a file and then convert that to table . 

 

 

 

Thanks
HImanshu

 

  • charrington's avatar
    charrington
    Advocate V
    3 years ago

    Thanks for the reply

    Yes you correctly understood the issue.

     

    But the idea of loading a file to Lakehouse in this scenario is not possible. First PowerApps, if you know a little about it, is a low-code app builder, so users can interact with live data, modify it or insert new records etc. So it's not about loading some data, the app sends SQL operations to the database for one or multiple records.

     

    Thing is in PowerApps there is no connector so far for Fabric. The closest we can use for now is the SQL server one:

    When creating a new connection, I enter the SQL endpoint string. This connection string is the same for Lakehouse and Warehouse. So using Lakehouse or Warehouse won't make a difference.

     

    Based on what you said with parall processing, it might make sense that primary key is not supported. But maybe another type of table to support Operational Data Store scenarios could be added. I will add the idea. 

    Have a good day