Excel - Power Query - how to create a new query based on the existing one

Question

I have created a number of power queries. So far I have done them by merging two sources (Merge as new). Now just want to extract from the existing query. I don't need to merge it with another one. I'd like to do some filtering on the query and save it as a new one. When I click on the query and edit (filter) it, it'd update the existing one. I'd like to save the results of my filtering as a new query.

I'm using Excel 2016 (O365). Thanks

Mike Honey · Accepted Answer · 2019-01-14 00:34:16Z

10

Find your "existing query" in the Queries & Connections pane. Right-click it and choose Reference.

You can also do this in the Power Query Editor window, from the Queries pane.

You will get a new query which picks up from the last step in the "existing query".

answered Jan 14, 2019 at 0:34

Mike Honey

15.2k1 gold badge29 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel - Power Query - how to create a new query based on the existing one

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related