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...
freder1ck's avatar
freder1ck
Kudo Kingpin
8 years ago

I would try setting the column positions manually ...

 

= Table.SelectColumns(#"Previous Step",{"Col 1", "Col 2", "Col 3", "Col 4", "Col 5"})

 

Fred

bbaranyai's avatar
bbaranyai
Frequent Visitor
8 years ago

Thanks Fred,

 

This definitely helps.

 

However I tried another thing...I referenced the Query in the Query Editor (right click, Reference). I did not make any change in the referenced Query....after Close&Apply, in the Data View the column order of the table of the Referenced Query was perfectly matching the column order of the Query Editor's (both the original and the referenced Query...). 

 

I am not sure if this is a feature or a bug :-)

 

Any idea?

 

Thanks

Balazs

  • freder1ck's avatar
    freder1ck
    Kudo Kingpin
    8 years ago

    I have no idea. Glad that you got it worked out!

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I am also having the same problem. It started when I created a new column and deleted the original column that was in the UNION in DAX. Now, as per the previous poster's suggestion, the new referenced table has the right column order but the original one still does not. I even tried using the manual table ordering in Power M step and the data table still shows the columns out of order. Even stranger, the field list on the right is in the correct order as per in Edit Query, but visualizing the table still shows an incorrect order. I can use the reference table instead of the original one in the meantime, but this seems to be still a bug.