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.
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.
Hi Shubham_rai955,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Community Support team.