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

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        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.