Forum Discussion

djimenez's avatar
djimenez
Frequent Visitor
2 years ago

PowerBI-Power Query: Merge Not Maintaining Matching Columns Order

Hello, I am expericing a strange issue with Power Query when I try to merge two tables.   I specify the columns I would like to merge in Table 1 with Table 2 here: When I click OK, it merges...
Need Help
scott_thomson's avatar
scott_thomson
Regular Visitor
2 years ago

Hi There, yes we have got the same issue which seems to have started out of the blue end of March or beginning of April.  There is nothing wrong with the M Code but Power BI interprets it in a different order.  I suspect this is a new bug introduced by a Microsoft Monthly release.

Even reselecting the order of the columns in the second join table does not fix this.

However I may have a workaround until Microsoft fixes this.  I suspect that it is ordering the columns in the second table according to the order they are defined in that table, hence the 1,2,3 etc.
So the workaround is to re-order the selection of the first table to match that of the second table.  So basically select the first table according to the default column order of the second. 

This seems to have worked for me.  However note that the Edit Step wizard view switches them again so cannot be trusted!