Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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 ...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
v-qiuyu-msft
Community Support
9 years ago

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's avatar
    Anonymous
    Not applicable
    9 years ago

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

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      9 years ago

      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's avatar
        Anonymous
        Not applicable
        9 years ago

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