Forum Discussion
Add column to dataflow and update Lakehouse
- 2 years ago
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)
I have tested the exact same thing and also see no new columns are added to the table in the Lakehouse.
Ehren, what you are linking too doesn't help. I see no way to manually edit the Output Destinations settings. Yes, you can select a new field for an already existing field. But I want the new fields to be added and there is no possibility for that as far as I can see.