Came across this article by Amal BEN REBAI on the topic of "Update Information from Power BI Report and Achieve Live Data Write-Back to Fabric Data Warehouse Using Power Apps & Power Automate". This shows another approach to something that there have been quite a few questions about recently!

Hi All, Recently our team has been testing writeback (making edits to the data source directly from PowerBI Report (any UI)). Currently working stack : Fabric Lakehouse, PowerBI Report, Powerapps __________________ Approach: Created a new lakehouse in fabric and then uploaded few csv's and started working with these as tables. These tables were loaded into a new semantic model (non-default) for usage. Now we have the powerbi report use this semantic model for reporting. In the powerBI we embed a powerapp visual. We edit the powerapp visual for new app creation. Here in the powerapp the connection is done using the lakehouse sql endpoint. _________________ !!!!!!!!!!!!!!! Main Concern !!!!!!!!!!!!!!!!!!!!! The approach use needs an primary key for performing edits to the data source. *** Fact being : I have looked at few blogs for guidance on how to workaround for the primary key creation in lakehouse, but wasn't able to do so. ________________ Any suggestions are welcomed, happy to cross check for validation and working.