Forum Discussion
Super UserWriteback using UDF to Lakehouse table
Hello Shubham_rai955 ,
Thank you for reaching out to the Microsoft fabric community forum.Directly updating a Lakehouse table using a Fabric UDF is not supported right now. Lakehouse is mainly for analytics, not for transactional updates.
If you need writeback from Power BI, here are the best options:
Use a Fabric SQL Database this is Microsoft’s recommended way because it supports UDFs and transactions properly or use a staging approach ,Send changes to a staging table and then run a notebook or pipeline to update your main Lakehouse table.Direct writeback into Lakehouse through UDF is not reliable today. Using SQL DB or staging will give you a stable solution.
Kindly refer to the below documentation links for better understanding:
Choose between Lakehouse and Warehouse in Fabric
Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.Regards,
Community Support Team.
Super UserHi Shubham_rai955 ,
A practical workaround is to route updates through a staging table (via Power BI or a custom app) and then trigger a notebook or pipeline to apply those changes to the target Lakehouse.
Alternatively, you can check out my custom visual + middleware approach, which I implemented to enable real-time writeback directly from Powe BI(premium or non-premium workspaces ).
Thanks,
Sai Teja