Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

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 cou...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Anonymous ,

 

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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    rdg515
    Resolver I
    5 years ago

    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?