Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Why does it create a remove function after a merge?



I've been struggling with this problem for a few days:


I want to join two tables with a merge (they have 4 common columns). I use an inner merge and then I save & close and, after that, Power Query itself creates a new remove function and they remove some of the columns I need. Even if I edit the tables and remove de function, when I save and close again, they automatically create the remove function again.


Can someone help me with this problem?


Thank you in advance!


Super User
Super User

Hi @fatima13 ,


My guess is that Power Query is doing this as an error-handling step to allow the query to load correctly.

Without being able to see the all the queries/code it's hard to be sure, but I'd check for duplicated column names as a result of the merge. This is particularly likely if you're using the Table.Join function rather than Table.NestedJoin.



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!

Helpful resources

Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

Top Kudoed Authors