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.
137 comments
-
PAC Man
commented
Why not have it match the excel limits for starters.
-
Pradeep Konda
commented
MSFT Support - Please let us know when the limit will be increased. It should be atleast 500K for excel to meet our business requirements
-
Eduardo
commented
Planned from March 31, 2018???? Its a joke!!! More than year ago.
Come on!!!! This feature is highly important and necessary. -
Anonymous
commented
The current limit is ridiculously low. As a Power BI Pro user I can only export 30k lines of data to CSV. Please consider raising it to the limits Excel allows for their workbooks.
-
Sagar Chhetri
commented
If Microsoft doesnt increase the limit of number of rows to export to .csv and .xlsx then we cannot be able to use microsoft Power BI as our enterprice solution. Please do the needful.
-
Rick Jordan
commented
Power BI Service needs to increase the limit for # of rows to export to .csv and .xslx.
This is in high demand by our business users in order to keep business momentum moving forward. -
mark ginnebaugh
commented
This seems like a very simple issue to resolve. I know there are many other priorities, but the workarounds for this limit take far more effort than I think an actual fix would take. Is there a specific timeline for resolution? Thanks!
-
Penny
commented
Why are limits necessary?
-
SueS
commented
Power BI Service needs to increase the limit for # of rows to export to .csv and .xslx.
Raise it to the limits Excel allows in a workbook. -
Greg
commented
+1 for increase this limit
-
rodman
commented
We are using Power BI Report server, and the limit is still 30000 rows. Power BI will not be an enterprise solution in our environment if this cannot be increased.
-
LuisCab
commented
Dear Nikhil, do you have any news about this subject?
-
Sireesha
commented
It's a common ask from users to be able to download large number of rows and columns for different purposes - for compliance, to share with external customers etc. The limitations of data export has been a major issue for user adoption in our organization. Please also support reliable export from SSAS live connections.
-
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.