Power M Query: Creating multiple temporary tables or new tables on the way to creating new table

[mikecrobp]

I have a large data source which I want to summarise in Power M Query before presenting to the Report side of PowerBI. That summary is in turn the join/merge of 2 summaries from the base data.

I could just have 2 queries and have one merge with the other. But that requires the data to be read twice.

Is it possible to have a query which:

1. Reads the base data and make any other changes needed
2. Create first summary table.
3. Create second summary table
4. Merge the 2. Expand required columns

I don't mind if the summary tables are visible to the rest of Power M Query - but they won't be visible to the report side.

I am maybe overlooking something very obvious but I have not seen this done and yet it is quite common for me to need to do this and would be good to have much quicker refresh times.

Mike

[v-yuta-msft]

@mikecrobp ,

Generally, to generate temp table, you can right click the original table and select duplicate. If there're more requirement, please post some sample data and clarify more details about expected result.

Community Support Team _ Jimmy Tao

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

[mikecrobp]

Thank you.

I have used Duplicate and Reference.

Both seemed to require a re-read of the source data  - which was taking a long time.

I was looking for a way of getting PowerBI to read once and then generate the 2 summary tables

Mike 

[rdg515]

I have the same question.  I'd like to build a summary table from the detail table with just one read of the detail table.  I also need to build the summary table in Power Query rather than DAX.  Is this possible?