Forum Discussion

ilcaa72's avatar
ilcaa72
Icon for Helper IV rankHelper IV
8 years ago
Solved

move column in query not reflected in data view

hello, using BI Desktop, i created a small test Table using 'Enter Data', 3 columns 11 rows.  I then created a calculated column, i then opened it in Query Editor to "move a column to beggining". I a...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    I can replicate this. If you really need a solution, use Advanced Editor and copy your query code. Create a new, Blank query and paste in this code. Delete your old query and rename this query to the old query name.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I think this must be a BUG, if you have several relations or calculated field, create a new query is not a good option,  I know this is the only solution, but every time a columns in a query change the order of this table change on data management view, because preserver the original order and add a the new columns to the end on the view, this still happened today on the most recent version 😕