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...
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
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?