Field's sorting in load script

[serjio]

I have load 4 tables from google analytics with idetntial fields.

i need to union this tables and work with union data, but field's sorting in one table is differ from other: http://joxi.ru/vAWDOn6S1kNabr

Why and how fix this trouble?

[v-sihou-msft]

@serjio

The sorting of fields is generated from the data source. You may check the Power Query for retrieving data in Advanced Editor. However, you can reorder the columns in Query Editor.

As your 4 datasets have same columns, different column sorting doesn't impact if you UNION those multiple datasets via "Append Query".

Regards,

Simon Hou