Hi Mynda/Phil/Catalin
I'm in the process of adding a new data set to my existing Power Query and Power Pivot model but before I add the new data, I want to test that I get the expected results by creating new queries in a separate workbook. That would be very time consuming as I have 12 queries some of which are helper/staging queries and the final ones are appended or merged queries. I know that you can copy existing queries and paste them into a new workbook but the problem I have encountered is that because these queries are based on combining files from folders, it exports the sample file, parameter and functions and I've had difficulties modifying these. At the moment I'm stuck with copying M code to Notepad and creating queries from scratch. What would you suggest?
Also, is there an add-in available for Power Query to more easily move back and forth between queries; something similar to DAX Studio for managing DAX code? I'm finding it a bit unwieldy trying to manage all these queries. If not, do you have any tips for managing queries, when to use references over duplicate queries, etc?
Thank you
Tim
Hi Tim,
If there is a query loaded to sheet, not just to data model, when you copy this sheet into a new file all queries and necessary parameters/functions should be automatically transferred into the new file.
Maybe it's a good idea to load the significant queries to sheet as well, in order to try this.
Hi Catalin
Thanks for your response. I was trying to re-use the queries in a new workbook but change the sample file and the combine query function that had been created so I could point my combine query to a different folder; this was the problem I was having. Anyway, I tried it again today and I've been able to change the query by pointing the sample file to the new folder; don't know what was going wrong the other day. Problem solved!
Thanks
Tim
