Skip to main content

    Power BI

    New

    Power Query Editor Copy behavior

    Vote (4) Share
    Gregory Deckler's profile image

    Gregory Deckler on 20 Jul 2021 22:00:18

    Copy behavior in Power Query Editor suddenly copies not just the query being copied but everything that query references. :(



    Suggestions:


    1. Put it back the way it was, nobody wants Copy to work this new way where it copies all underlying queries, parameters, functions, etc.

    2. Perhaps an Option in Options and settings to set whether copy works the old way or the new way

    3. Create two copy options, Copy and "Copy All" with Copy being the old way and Copy All being the new way. Provide an Option in Options and settings to default Ctrl-V to one or the other

    Comments (2)
    Gregory Deckler's profile image Profile Picture

    Kieran Leigh on 10 Nov 2022 09:50:03

    RE: Power Query Editor Copy behavior

    The copying of dependencies works for me when I'm creating a new report, because it saves having to follow through exactly how the existing report is configured and gets me what I need.The problem is when copying an item over to an existing model. It will bring over a second set of dependencies. There should be control over how dependencies conflicting with existing items is resolved.

    Gregory Deckler's profile image Profile Picture

    Michael Marx on 05 Aug 2021 16:11:23

    RE: Power Query Editor Copy behavior

    I'm inclined to go for option 3.