Increase Export Data Limits
In late 2016, Power BI improved our export data options to allow exporting up to 150,000 rows to Excel from a visual on a Power BI dashboard for Pro users. If you require higher limits, please vote on this idea. If you have more specific requirements, please leave them in the comments.
AdminAdam Wilson (POWER BI)
(Product Manager, Microsoft Power BI)
shared this idea
Thanks everyone for your feedback. We’ve started to explore various options to increase this limit. Stay tuned for updates.
124 comments
-
David Erickson
commented
Is there another update on this?
-
stefano
commented
We would like using PowerBi Pro for Azure chargeback reporting. We have reporting in place using tags but this limitation is very annoying. Usage details report from EA portal have about 300000 row per month.
-
Earle Lindfors
commented
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. Power BI is too powerful and valuable not to.
-
Matthew Kiley
commented
We are using Power BI Report server, and the limit is still 30k. Power BI will not be an enterprise solution in our environment if this cannot be increased.
-
M
commented
This was planned a year ago. Any idea when this will be released?
-
Anonymous
commented
Agree to have max row limit of excel.
-
Kurt Barajas
commented
My company recently began using Power BI and the row limit continues to be a severe limitation. The data from visualizations and tables needs to exported for validation and to be sent to other parties.
I find myself taking many small chunks of data but as soon as we change part of our model, we have to go through the tedious task of re-exporting. Every single time.
-
Rolen Lo commented
How long do we need to wait further?
-
Ramy
commented
People will start losing confidence in this tool since raw data is limited to 150K and they cannot validate or do analysis properly.
Please can you increase the limit to match excel.
Thanks
-
Anonymous
commented
Are there any updates related to removing the export limitation in Power BI Reporting Services? Will this be in the May, 2019 PBIRS Release?
-
Lee Haakenson
commented
Definitely need to remove this limitation. We are evaluating multiple options, and this would definitely be a deal breaker for my organization.
-
Anonymous
commented
definitely need no limit. drill downs are basically unusable unless you set a filter and then tie the data back together after exporting.
-
Anonymous
commented
+1 for increasing or removing the limit for Power BI Report Server.
-
Anonymous
commented
It's been a year and admin promise to increase a year ago but nothing. meh.
-
Rafael Borghi
commented
Also, it should allow to increase the export limit for Power BI Report Server (and not only to Power BI Service)
-
Art Allmon
commented
My end users are barking about getting only partial data sets and having to download via multiple requests. Not a good thing. Excel can handle more than 150,000 lines per sheet. Please broaden the interface to allow for a higher number of records exported.
-
Marc Hilti
commented
any update???????????
-
Vicky M
commented
Hello
Please increase this limit. -
Kalvis Vasks
commented
Match the row limit from Excel
-
Chris Nguyen
commented
Match the row limit from Excel