Overwrite columns

[Igor]

[FONT=&quot]Hi,[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]When I add column only in excel (the data loaded from power query) and after it I add another column in power query. The column from power query overwrites the column I added in excel.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]How can I change it?[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Thanks![/FONT]

 

[MarcelBeug]

Cross posted.

 

[Igor]

Cross posted.

This is different forum. What do you want?

 

[Ed Kelly]

Not quite sure of your exact question (always better to attach file with dummy data) however believe your problem is that you need to be adding new columns either in the source data table or by introducing it in PQ as a custom/calculated type column. DO NOT add columns to the queried result else it will get overwritten on each update/refresh

Knock 'em dead sailor!

 

[Ken Puls]

This is different forum. What do you want?

Please have a read of this article. It explains what we (and other forums) want with regard to multi-site posting.