Add Column After Publishing

[igreenhalgh]

After I published a table to my Lakehouse, I seem to be unable to go back and add a new column in the Dataflow without deleting the Lakehouse table first, adding the new column, then setting the destination again. This means I have to go back into the SQL Endpoint each time to rebuild the model, including column formatting for Power BI.

[Anonymous · Accepted solution]

Hi @igreenhalgh ,

Thanks for using Fabric Community.

Apologies for the issue you have been facing. Currently adding new columns in a Lakehouse table is not supported in Fabric. This is the reason you are not able to add a column after publishing the Dataflow Gen2.

Please refer to this document for more information: Link1

Hope this helps. Please let us know if you have any further queries.

[igreenhalgh]

I see. Well noted! Hope this functionality can be added in the future!

[Anonymous]

Hi @igreenhalgh ,
Glad that your query got resolved. We will definitely try our best to add this functionality.
We could certainly keep an eye for upvote. Appreciate if you could share the feedback on our feedback link , which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.
Feedback Link : Home (microsoft.com)
Thanks.