Forum Discussion
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
- mahenkj2
Solution Sage
Hi Anonymous
You may have simply first googled it.
Pls refer this:
https://radacad.com/say-no-to-export-data-yes-to-analyze-in-excel-power-bi-and-excel-can-talk
Hope it helps!
- AnonymousNot 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
Solution Sage
Hi Anonymous
Have you tried it. I see it opens from one drive and in pivot view only.
Hope it helps.
- Mayuri_Ghosh
Helper I
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
- AnonymousNot 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.