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.
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.
D Reinman commented
This is a major limitation, which is causing us to reevaluate the use of PBI. All of our customers have "export underlying data" as a basic requirement. Tableau allows user-friendly crosstab exports of over 33 million cells (or 1 million records of a 33 column table). If you hope to compete with Tableau and retain business, this should be a top priority (instead of forcing our report builders and users to jump through additional hoops with drill-through and paginated reports).
Microsoft - PLEASE ADDRESS THIS ASAP.
Alternative solutions are not feasible at all.
For Eg we evaluated Paginated Reports - very basic, It has its own limitations
Embedding Report in App to overcome this limit?? Seriously? Then what is the purpose of having one central portal. How many report should we embed?
Angelfish 42 commented
Have just found out there is a limit of 150,000 rows when exporting to excel? We are trying to switch reports from another reporting tool (not the reporting tool mentioned in a previous comment) which does not have this limit at all and exports to excel without any problems.
Samik Pal commented
Hello Power BI team. This 150,000 limit on row export is a deal breaker. The end users in my organisation are already complaining about this. We have accounting and GL level transaction dashbaord for our end users. For YTD data the exports are often more than >150k. Please guys work through it to allow more rows to be exported. I brought Power BI and replaced Tableau in my client account in my company. Power BI is far better than Tableau for million reasons except this limitation. Tableau has no limitation on row export. Please work through it and devise a solution ASAP.
Any updates on the progress with this?
Concur. FIX this... match the row limit of excel.
JUST FIX IT AND STOP MAKING PLANS!
I can't even get what I need with premium. This is absurd.
There is no practical reason to uniformly limit downloading data, especially when trying to download from a desktop version onto the computer where the pbx file is stored.
My frustration with Power BI continues.
Evandro Scarton commented
This 150k limit seems very simple to be solved by the Power BI team. I am, or was until I discovered this, deploying to 80 users in my organization. I’m going to rethink a lot if I’m going to go ahead with Power BI or target Tableau or Qlik Sense.
Hello, I kind of disagree with you.
"Customers who have Power BI Premium can set a drill-through to paginated reports via URL parameters as a workaround in the interim" => it is possible only if the number of character in your filter is lower than 2.500. You put one mutliple selections and the paginated report wont match with you report (cause of the values of the filters).
Any idea how to solve this ?
Data Analyst commented
Please match export limit to Excel limit.
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:
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)
text = paste(now, "
", var1, "
has been created")
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?
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.
Is there any update? As this matter is urgent, I would appreciate a reply as soon as possible
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.
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