How to append Query with the Final Applied Step Only, not all the previous applied steps.

Thank you for the Suggestions. I did find a solution/workaround that allows appending mutliple quieres while still keeping unique data without duplicating wrong data references.

The problem was that my "FluidID" references the "TestID" but the TestID is not unique. So when I appended it, my FluidID was duplicated becasue it referenced the Test ID twice. The Duplicate data was incorrect because it belonged to a different FluidID. This happens because appending Query 1 into Query 2, then PowerBI follows all the applied steps previously in Query 2. Shown in picuture

The solution was to create a blank query table. After that, append both query 1 and query2  to the blank query. This allows PowerBI to only focus on the "last" applied step of each query 1 and 2.  This inturn keeps each referenced TestID to the correct FluidID in my example. So no wrong duplicates are created. Shown in picture. 

I'm surprised this problem isn't brought up more, because it will occur each team someone adds mutliple yearly data that have repeating ID columns that are not unique. But the solution I see is to create a blank quiery table. 

Problem with Duplicate wrong data reference after Appending Query 1 into Query 2

Solution: Create Blank Query and append Query 1 & Query 2 into the Blank Query.