Forum Discussion

Shubham_rai955's avatar
Shubham_rai955
Super User
10 months ago
Solved

Writeback using UDF to Lakehouse table

I am building a writeback solution in Microsoft Fabric using a Lakehouse table but facing the issue. The goal is to let users (for example, from Power BI) update specific records in a Lakehouse data...
workspaces
  • v-hjannapu's avatar
    v-hjannapu
    10 months ago

    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.