Forum Discussion
Bug: move column in query not reflected in data view
Hi,
I moved a cloumn "Key" in Query editor to the begining as shown below but the same is not reflected in Data in view.
I found a link that provides a solution to this
But i think the option given in the tool to rearrange the columns should work seamlessly wihout any issues.
can this be reported as a bug and fixed in upcoming releases? i am currently using the June release
Regards,
Diptesh
Hi Diptesh,
I'm sorry for misunderstand your issue.
If we want to update the column re-arranged format in Data view. You could follow the steps below.
1.Go to Editor Query and re-arrrange the column and then right click table, untick the option Enable Load.
2. Close and Apply
3. Click Editor Queries, and right click table, tick the option Enable Load.
4.Close and Apply and Click Refresh in Data view, then you could see the update column arrange.
Best Regards,
Cherry
9 Replies
Hi Diptesh,
But i think the option given in the tool to rearrange the columns should work seamlessly wihout any issues.
can this be reported as a bug and fixed in upcoming releases? i am currently using the June release
This is not a bug, it is by design. We could only move the column in Query Editor then apply it to Data view.
In addition, you could vote this similar idea in Power BI idea Forum.
Best Regards,
Cherry
Hi v-piga-msft,
The issue here is that the columns re-arranged or moved using the query editor are not reflected in the Data View once i click close and apply. Please refer to screen shot in my first post.
Regards,
Diptesh
Hi Diptesh,
I'm sorry for misunderstand your issue.
If we want to update the column re-arranged format in Data view. You could follow the steps below.
1.Go to Editor Query and re-arrrange the column and then right click table, untick the option Enable Load.
2. Close and Apply
3. Click Editor Queries, and right click table, tick the option Enable Load.
4.Close and Apply and Click Refresh in Data view, then you could see the update column arrange.
Best Regards,
Cherry
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 😕
