Trying to Reorder Columns in Data View in Power BI

Question

Is there a way I can reorder columns in 'Data View' within Power BI? I tried doing it in Power Query first but when the data loads into the table, the columns automatically rearrange.

Answer 1

It is extremely stupid way, but it is working - i found it by accident:

1. In edit query view remove the column, then save changes. You will see that in data view that column was removed as well.
   
2. Now again in edit query view remove from applied steps the action that removed the column. Save it again.
   
3. You will see that removed previously column was added to the end of the table.
   
4. This way you can arrange your columns to have it the way you want it in data view.

Hope it helped.