topic Re: Add Column After Publishing in Dataflow

Add Column After Publishing

igreenhalgh — Thu, 02 Nov 2023 20:18:11 GMT

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.

Re: Add Column After Publishing

Anonymous — Fri, 03 Nov 2023 06:35:02 GMT

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.

Re: Add Column After Publishing

igreenhalgh — Fri, 03 Nov 2023 12:58:27 GMT

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

Re: Add Column After Publishing

Anonymous — Fri, 03 Nov 2023 15:24:27 GMT

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.