Export Summary Table

[Anonymous]

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!

[ankitpatira]

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

[Anonymous]

@ankitpatira

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-msft]

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 Templates

Best Regards,
Qiuyun Yu

[Anonymous]

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

[v-qiuyu-msft]

Hi @Anonymous,

Another available way is to put all table fields into a table visual and set visual level filters, then export data. See: Export data from Power BI visualizations.

Best Regards,
Qiuyun Yu

[Anonymous]

But this only works for up to 30,000 lines, correct?

[v-qiuyu-msft]

@Anonymous You can see the Note section from the article I posted:

The maximum number of rows that can be downloaded is 10,000.

In the table visual, you can add filters to filter table data less than 10000 rows then export data.

Best Regards,
Qiuyun Yu

[Anonymous]

I need to be able to do much, much more than that

[Anonymous]

Still looking for a way to do this efficiently and without error. Getting errors from trying the right click -> copy table -> paste in .txt file. Is Power BI not powerful enough to handle such large data? We are requesting more historical data, so it is only going to get bigger.

[Greg_Deckler]

What is your live data feed? Is it Azure Streaming Analytics or is it Direct Query or something else?