Forum Discussion

alfredas81's avatar
alfredas81
Frequent Visitor
8 years ago

Order of columns changes in Data View after Edit Query phase

Hi, I am new to Power BI, but I can not understand why the order of columns which was in Edit Query phase(no reordering was applied to column order) changed in Data View.  Order of table columns in...
alfredas81's avatar
alfredas81
Frequent Visitor
8 years ago

Hi Yuliana Gu,

Data source is join of multiple SQL statements. Actually no conditional/custom columns were added to original table in Edit Query phase:

 

The problem is that I use this table to join with tables which has the same structure, and because column order is changed, union function does not provide correct results in Data View phase.

bbaranyai's avatar
bbaranyai
Frequent Visitor
8 years ago

Alfredas81 and Yuliana,

 

I have the same problem.

 

I am combining data from multiple excel sheets in my query. One of the columns in the main query is created by using a lookup table (merge queries). This column appears in Query Editor in 72th position....when I close and apply it moves to 75th position. Only that column...all the other columns in Data View match their positions in Query Editor.

 

Thanks and regards,

Balazs