Adam Wilson (POWER BI) on 24 Feb 2017 01:34:44
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.
Administrator on 30 Jul 2020 16:56:47
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.
- Comments (158)
RE: Increase Export Data Limits
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.
RE: Increase Export Data Limits
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.
RE: Increase Export Data Limits
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 ?
RE: Increase Export Data Limits
Please match export limit to Excel limit.
RE: Increase Export Data Limits
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))
RE: Increase Export Data Limits
3...years...later....
RE: Increase Export Data Limits
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?
RE: Increase Export Data Limits
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.
RE: Increase Export Data Limits
Dears,
Is there any update? As this matter is urgent, I would appreciate a reply as soon as possible
Thank you
RE: Increase Export Data Limits
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.