Export Summary Table

Anonymous

1. Make summary table = There is no out of the box feature that will automatically make summary table for you. You will have to do that via query editor ie filter out your data, remove columns, make sum of certain columns, group by etc to make it like summary table.

2. Export out as pbix file = Unless you want to make a copy of pbix file after creating summary table in above step you can also export out a template file which when opened will ask for crredentials to connect to your data source and can then be saved as another pbix file.

So I would suggest, you via query editor use group bys and filtering to create a summary like table then close&apply and export it out as power bi template then again go back to query editor for original pbix file and remove the steps you applied to create summary table.