Columns not in the correct order in the table

[Anonymous]

Hi everyone,
I have a problem with the way PowerBI is ordering my columns. I used the "select column" feature in the PowerQuery UI to select just a bunch of them, then I loaded this change to the data model. After that I decided that I needed 2 of those columns and I added them back in the "select columns" list and loaded again. The problem is that now these columns are at the end of the table, even though in PowerQuery they are, correctly, displayed as the first 2 columns. How can I solve this?

[v-easonf-msft]

Hi, @Anonymous 

In PowerQuery,you can directly drag the selected column  field to change the position of the column.

However, if you are referring to changing the order of the fields in the report view or data view as follows, I ’m sorry, it currently does not support custom sorting of column fields.

 filelds in report view

  

fields in data view

For your requirement , you can come up with a new idea and add your comments there to make this feature coming sooner. https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I'm sorry I think I wasn't very clear

My requirement is not to be able to drag and order columns in the data view or report view.
The problem I have is that the columns in PowerQuery have a certain order (the correct one) and they have a different order in PowerBI (in the data view)

This happens when I go in the "choose columns" feature of the PQ UI and add columns to my selection. As example:

Let's say I have a table with columns A,B,C,D,E

I use "choose columns" and tick only B,C,D,E. This generates a "table.selectcolumns" string of code in my PQ step.

I apply the changes. After that I go back in PQ and in the same step I tick also column A.

Now the problem here is that in PowerQuery column A figures as the first column but in PowerBI it is generated as the last column of the table. I can't use the reorder columns feature since it is the first one already.

Is there a way to solve this?

[v-easonf-msft]

Hi ， @Anonymous 

Do all your steps look like this?

step1

step2

step3

step4  :

If so ,it is suggest to add following steps .

Step 1 :uncheck  the option "enable load to report"   and apply changes 

It will show nothing in  data view.

Step2: recheck  the option "enable load to report"   and apply changes 

The data view will show below:

Best Regards,
Community Support Team _ Eason

[Anonymous]

Great!! Thank you