Forum Discussion

dragonus's avatar
dragonus
Icon for Helper III rankHelper III
6 years ago

Is there a way to convert duplicate query to reference query?

Made a mistake, but do not want to delete my original duplicate query and create new reference ones in fear of my visuals going haywire...

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi dragonus 

     

    I tried this on one of my reports and it worked.

    Go to the Power Query Editor and select the Duplicated query, then click the Advance Editor.

    Pay attention for the text in bold here. 

     

    let
    Source = #"original Query name"
    in
    Source

    This changes the query to reference

     

    Did I resolve your issue? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!!

     

    Regards,
    Pranit

     

     

     

     

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support

    Hi, dragonus 

     

    You may create a new query which has a reference to the original table and then apply the steps in the duplicate table to the new query. About references in Power Query, please refer to the document .

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.