How can we improve Power BI?

Increase the data export row limit (30,000 rows max) in Power BI Report Server

The capability to export raw data from Power BI is an important function for many users.

Presently, the export data limits are as follows and confirmed at the community link below.

- Power BI Service (cloud platform): 150,000 row maximum
- Power BI Report Server (on-premise platform): 30,000 row maximum

Please increase the export limit setting on Report Server to match that of Service. Better yet, increase them both to a much higher limit as requested by others in separate idea posts.

http://community.powerbi.com/t5/Report-Server/What-is-the-Export-data-row-count-limit-for-Power-BI-Report/m-p/343951

443 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Ken Wetherell shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

26 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • John Qiu commented  ·   ·  Flag as inappropriate

    Please work on this idea. Ad hoc requests require the raw data. Can't build a tab in reports for each request.

  • Earle Lindfors commented  ·   ·  Flag as inappropriate

    Very difficult to advocate for this product to support the "Enterprise" with this kind of limitation on export. With migrations to Windows 10 builds 1709 and 1803 of interest to DOD, this capability is perfect for tracking progress. However, when looking to take action on the results (which will certainly exceed 30K records) during the initial phases, it renders the capability short of supporting Enterprise requirements. PLEASE put your best engineers on this issue ASAP. PBIRS is too powerful and valuable not to.

  • Onboarding User commented  ·   ·  Flag as inappropriate

    We must be able to have the limits of Excel in the extraction, this is must for us since we have a lot more lines of what we are able to extract for the moment!
    Please look in to this feature for the benefit of all of us!

  • Sadhya commented  ·   ·  Flag as inappropriate

    YESSS! This is so important it is a deal maker or breaker. What do you do with this massive fabulous tool when your reports aren't complete because it can't handle the download? Match the 2016 Excel limit.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Both report server and service and PBIX desktop should have much, much higher export limits, for both CSV and Excel. Currently... service (150K, csv/Excel); report server on prem-platform (30K); PBI Desktop (30k, csv)

  • Carlos Brenes Víquez commented  ·   ·  Flag as inappropriate

    We would like to share our reports on a wider basis and to maintain them on one central place, but we need to increase the download limit on the web-platform of the Power BI server.

  • Anna Whisenhunt commented  ·   ·  Flag as inappropriate

    I second the request to increase (or eliminate) the limit on the report server. Our business processes more than >30000 transactions at once; while there is a work around, it is disruptive and time consuming.

  • Markus commented  ·   ·  Flag as inappropriate

    Please increase the download limit on the report server. I guess it has been set to not reduce performance but if it's running on an own server environment it would be good to let the customer decide what is more important - speed vs quantity. I suggest to make the download limit part of the customization of each individual Power BI report server admin.

  • Manish Siwach commented  ·   ·  Flag as inappropriate

    Hi Chris, Any update on lifting the 30k limitation on Power BI Report Server. Earliest reply is of great help for us to decide on Power BI or Tableau.

  • Kenny Miller commented  ·   ·  Flag as inappropriate

    Hello all,

    We are excited about what Microsoft is doing in the space of data visualization but it would be very beneficial to our customers to increase the export limitation to 150,000 rows. Can you please update us on the status of this item. How many votes do we need?

  • Anonymous commented  ·   ·  Flag as inappropriate

    Hi Chris,

    Do you have any updates on removing the row restriction when exporting from PBI RS?

    Thanks,
    Liam

  • Jeff Messer commented  ·   ·  Flag as inappropriate

    One more bump on this, first posted in January, Chris commented mid-year, it's now December...lifting these kids of limits really should be a priority.

  • Vic commented  ·   ·  Flag as inappropriate

    PowreBI is very limiting in what it can do. Tableau on the other hand can export 1M rows vs PowerBI is limited to 30K rows. I don't get why Microsoft provides tools which are so half baked.

  • Karine commented  ·   ·  Flag as inappropriate

    Any update ?
    All settings we put on previous version are now completely unuseful due to this limitation

  • Mary Barber commented  ·   ·  Flag as inappropriate

    Hello,
    are there any updates to this issue? We just had a PBI upgrade, and now have the 30k limit, which is causing many difficulties for us. This limit definitely needs to be removed. Thanks so much!

  • Anonymous commented  ·   ·  Flag as inappropriate

    Hello, any news about this limitation?
    As can be seen, as a table option, for example, the option of number of lines per page, limiting each page to 30 thousand lines, but for data export this limit has to increase.

← Previous 1

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.