Forum Discussion
Export Summary Table
Hello,
I have a very large live data feed. 20,000,00 rows to be exact. What I would like to do is make a summary table from this data, and export it as another .pbix file to limit space and time used. Any ideas of ways to do this? Thanks!
10 Replies
- Greg_DecklerCommunity Champion
What is your live data feed? Is it Azure Streaming Analytics or is it Direct Query or something else?
- ankitpatiraCommunity Champion
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.
- AnonymousNot applicable
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.
- v-qiuyu-msftCommunity Support
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 Yu