Forum Discussion
Add column to dataflow and update Lakehouse
Currently, you cannot modify the Data Destination schema from the Power Query Online editor. Instead, if you want to change the schema of a Data Destination, you need to do it in the editor for the Data Destination itself.
This may change in the future, as we release new functionality. I would recommend posting this in the Ideas community as it will help highlight the need for this: Home (microsoft.com)
Hi, Any update on this thread Ehren I have the same issue also Dataflow gen 2 published with 4 columns received some user feedback and a request came in to have 2 more columns update the dataflow and check the destination update schema it only pulls the columns created in the lakehouse the only force of hand I have found is to delete the table/s in the lakehouse first then the destination schema updates feel like there is a bug in the check of the data flow vs the endpoint schema as deleting the table 1st does show a message that the schema has changed which I would expect to see without deleting the table also it should detect column changes of type and additions or removal of columns in the thread posted it seems like the user created the table with all columns but did not apply the mapping she when they went back the user applied the mapping and problems solved.
Currently, you cannot modify the Data Destination schema from the Power Query Online editor. Instead, if you want to change the schema of a Data Destination, you need to do it in the editor for the Data Destination itself.
This may change in the future, as we release new functionality. I would recommend posting this in the Ideas community as it will help highlight the need for this: Home (microsoft.com)Hi! as mentioned by jwelch earlier in the topic, this is currently a known limitation. You can go to the Fabric ideas portal to request this capability as a new feature:
The product group reviews all ideas and your input will help them prioritize this work.
Thanks for the feebdack!
