Forum Discussion

Ctisa87's avatar
Ctisa87
New Member
3 years ago

Self-referencing Columns Won't Stay Put Upon Power Query Refresh

I'm using a large google sheet as my source table and pulling the raw data into an excel spreadsheet via power query. From there, I have added multiple columns to the table that reference the columns...
Need Help
jbwtp's avatar
jbwtp
Memorable Member
3 years ago

Hi Ctisa87,

 

There is a command in PQ Table.ReorderColumns() which deals with this.

Just manually (using your mouse) move the colunms into positions that you prefer them to be and they should fall into places in the output.

 

Cheers,

John 

Ctisa87's avatar
Ctisa87
New Member
3 years ago

Does this solution work for columns that are not part of the power query? For instance, the columns that move are the ones I add in excel after the power query has already been performed.

  • jbwtp's avatar
    jbwtp
    Memorable Member
    3 years ago

    Hi Ctisa87,

     

    I beleive so. In my testing the structure of the table (columns order), which I set in Excel did not change after data were updated in the origial table and refreshed. Below "blue" table is the source data, "green" table is an output of a simple query, which reads and returns the source data, Tx columns are manually added in Excel and are not part of the dataset returned by PQ: 

     

    Cheres,

    John