Adding Append Query to beginning of Applied Steps in Query Editor

[Anonymous]

Hello,

I have two tables I am trying to append (Transaction Log and Transaction Log History). Their original states have the exact same columns and column names. The only different between the tables is that Transaction Log has the last 30 days of transactions while Transaction Log History has every transaction prior to the last 30 days. Transaction Log already has a large number of applied steps, such as, renaming columns, changing types, and removing columns. I am trying to find a way to append Transaction Log History to Transaction Log and have the append query step occur at the beginning of my applied steps (i.e. prior to all of the renaming/changing/removing/etc.).

Any help is greatly appreciated.

[Washivale · Accepted solution]

Hello @Anonymous ,

If i understood your post correctly, you are looking to add an append step at the beginning of your other steps, Probably post navigation, You should select a step from your applied steps and hit append queries option from Menu, powerbi will ask if you want to insert step, just click insert and it should add append query in the beginning.

Thank you,

Washivale