I've got a large number of input files which I process with a single power query. Using this I manage to read 100's of CSV files, manipulate the data and create a single table.
I now want to create two output tables from a single query.. e.g. 1st output table has all the input data and a 2nd output table with a subset of the input data. Can a single query create multiple tables?
I could run two queries, but seeing as an individual query takes 10 mins to run, I don't really want to run it twice.
Hi Peter,
Welcome to our forum!
If you right-click the first query in the left hand query list of the Power Query editor, then select 'Reference', you'll create a second query based on the first query.
In regards to the slow refresh times, please see this link on ideas for improving Power Query refresh times.
Mynda
The hint about speeding up refresh times has really made a difference.. reduced the load from 10 mins to 2 mins...
Wow, great result 🙂
