Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

export more than 500k rows

Hi,

 

Is there any way to export more than 500k rows in power bi without using report builder. 

 

Thanks in advance.

 

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      I have googled and didn't found aprt from paginated report which seems too slow. The link u provided will not help as end user needs to create the pivot view .

      • mahenkj2's avatar
        mahenkj2
        Icon for Solution Sage rankSolution Sage

        Hi Anonymous 

         

        Have you tried it. I see it opens from one drive and in pivot view only.

         

        Hope it helps.

  • Hi,

    You can export up to 500k rows by using this option for a single visual. Things to remember is that you have build permission on the dataset.

    This way you can analyze more than 500k rows.

    Another way can be you can use paginated reports as it can print every row and use as many pages as necessary while exporting.

     

    Thank You

    • Anonymous's avatar
      Anonymous
      Not applicable

      This I am aware but it only allows upto 500k. I have rows more than 500k. Paginated report performance is very slow. So avoiding it.