Why is Power query transform data and the close and load not in the same order?

Power Query
1

Hallo,

When I query data ( first screen shot ) and close and load the data ( see second screen shot )

the order of the columns has changed,i Need the exact order of screen shot 1
what is the reason for this beharviour and how can I fixed this ?

thanks in advance

Roger

image
image945×223 69 KB

image
image934×302 95.9 KB

2

Hi @Roger,

I would check your steps in the power query to see if you accidentally moved columns.

Have you tried DataMentor/ EDNA AI to see if comes up with an answer?

thanks
Keith

3

@Roger here’s my take…

I’ve noticed that when you add new columns after you’ve already closed and loaded your data, these columns always show up at the end of the table in table view. One trick that might fix that is to disable the load, which removes it from the model (Close & Load), and then enable it again. That will update the model schema, but I didn’t test this myself so I’m not sure…

However, you can’t visualize a table’s view directly in a Power BI report, so the order of the columns shouldn’t really be a problem. You have complete control over the column order within a table or matrix visual on the report page.

4

Melissa

thanks for the info, It wasn’t a problem of visualisation. I wanted to append 2 tables but the order of columns was different

kind regards
Roger

5

Hi @Roger

As @Melissa said, the order of the columns doesn’t matter betweeen Query Editor and Data View. The order of the columns also doesn’t matter when appendiing in Power Query/M. If you do want to reset the column order for personal preference reasons, I posted a hack a few years ago that may be of interest:

Hope it helps.
Greg

1 Like