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 used. Any ideas of ways to do this? Thanks!

10 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

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

  • ankitpatira's avatar
    ankitpatira
    Community 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.

    • Anonymous's avatar
      Anonymous
      Not applicable

      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.