Forum Discussion
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...
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.
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