Forum Discussion
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.
Maybe I am missing something simple, but after editing in the query, I am not seeing how to export once the data is manipulated how I want it.
Hi Anonymous,
You can apply the modification in Query Editor then close. Back to the report, you can see Export-> Power BI template.
Reference:
Deep Dive into Query Parameters and Power BI TemplatesBest Regards,
Qiuyun YuRecieved errors when filtering in edit queries screen. Figured out a way to get this done.
Created a calculated table based on the old data with a filter
Right click the table on the right side, and select copy table
Paste into a text file
Load text file
It works and will be fine, still looking for a better and more efficient way though since we will have to update these.
