after union two table, data go to wrong column

[Anonymous]

when I union two same table, most data go to wrong column,  who know how to fix this error, thank you

[v-yulgu-msft]

Hi @Anonymous,

This problem is caused by the different column orders of two tables.

The displayed column order in table view is not matched with that in the right fields pane. Please see below example:

Best regards,

Yuliana Gu

[CathyPalmer]

I know this is an old post but this may help others experiencing union problems. I found this tip re re-ordering columns in data view. Apparently the column order is determined by when the columns are added and not necessarily how you see them in Power Query. Tip: How to Change Column Order in Data View - Power BI - Enterprise DNA Forum

[Anonymous]

Yes, true, two table column have different order like your example, how to fix this without code ?

How to let data to show  with right side column order? 

in the Edit Query Mode, my table with same column order, how they change column order by Data tab?

Thank you for your help

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

You could modify the DAX for calculated table as:

Result Table =
UNION (
    SELECTCOLUMNS (
        Table1,
        "Column1", Table1[Column1],
        "Column2", Table1[Column2],
        "Column3", Table1[Column3]
    ),
    SELECTCOLUMNS (
        Table2,
        "Column1", Table2[Column1],
        "Column2", Table2[Column2],
        "Column3", Table2[Column3]
    )
)

That way can keep the same order for columns when you union two tables.

Regards,

Yuliana Gu

[Anonymous]

I have the same problem, and your solution would work just fine BUT I have ten tables each with ten columns. I would then need a cumbersome UNION SELECTCOLUMNS with 100 lines !!!

Do you know of any other way to ensure columns remain in the same order, thus avoiding this workaround ?

[dennissheehan]

Excellent solution.

My tables were generated in DAX so I could not use power query to join

I tried union for a lot of tables and luckily the columns match up but sometimes they did not so this method helps me avoid being lucky in using union and rely on accurate coding instead.

Most Grateful  

[Narukkp]

Thank you so much. Your answer saving my lot of time...

[Hisham]

Great answere ! very usfull.

[parry2k]

I never used union as such, did you tried using "append" in power queyr and see if it works.