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
There are longer term plans to allow larger exports in that use case, but there isn’t a current timeline as to when that will be available. Customers who have Power BI Premium can set a drill-through to paginated reports via URL parameters as a workaround in the interim, as there is no data export limit for paginated reports.
146 comments
-
Jack
commented
Tableau has no limit. Just saying.
-
Guus van Zuylen
commented
Install R to enable R script visuals.
Create the table to be exported.
Copy this table and convert the copy to a R script visual.Enter the followning code:
require(gdata)
par(mar=c(1,1,1,1))
now <- Sys.time()path1 = "C:/PowerBI/"
# comment: change the back slashes in C:\PowerBI\ into forward slashes
var1 <- "test.txt"
write.table(trim(dataset), file=paste(path1, var1, sep = ""), na="", dec=".", sep = "\t", row.names = FALSE)
library(RGraphics)
library(gridExtra)
text = paste(now, "
", var1, "
has been created")
grid.arrange(splitTextGrob(text)) -
drg
commented
3...years...later....
-
Jason Campbell
commented
I might be speaking solely from my vantage point, but I do not know any developer that wants the added work of creating a paginated report when the data is already displayed in a report ready format (encourage the customer to right-click, export to Excel). I also do not know an end user who would rather drill through and use a paginated report unless it was designed to be a paginated report. Seriously. Yes, both methods have their uses, but everything >150k records shouldn't default to paginated.
It's also hard to understand why the drill through process is only available to Premium. We have Premium and expect more. It feels like the interim work around is a band aid that should be available to everyone.
Any update on when we can export a table/matrix in xlsx format vs. csv? If and when this becomes a reality (like it is and has been w/other BI platforms), will the limit still be 150k records, or will the Excel limit be applied?
-
Shane
commented
150,000 limit on service is severely limiting our users similarly. The most painful part of this for us though is that there is no error message when we exceed this limit on service.
We have found cases of users downloading/exporting incomplete data sets and using it in their business reports because the did not notice the data was incomplete. -
Tsogtb
commented
Dears,
Is there any update? As this matter is urgent, I would appreciate a reply as soon as possible
Thank you -
Christos Christodoulou
commented
This limitation is ridiculous for an enterprise product. We are forced into workarounds of SSIS or DAX queries directly on the analysis server for simple data exports.
-
Bala N
commented
Nikhil/MSFT Team, Please let us know the latest update on this.
-
Jay
commented
Need this limit to be elevated ASAP please
-
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.