Skip to main content

Power BI

Completed

Increase Export Data Limits

Vote (1854) Share
Adam Wilson (POWER BI)'s profile image

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 01 Feb 2023 00:01:36

WWe ha a new feature that provides an increased limit of 500K rows of data to Excel from a Power BI visual. Learn more...Announcing Connected Excel Tables from Power BI (Public Preview) | Microsoft Power BI Blog | Microsoft Power BI

- Ikechukwu

Comments (178)
Adam Wilson (POWER BI)'s profile image Profile Picture

Nigel on 06 Jul 2020 00:12:23

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.

Adam Wilson (POWER BI)'s profile image Profile Picture

Evandro Scarton on 06 Jul 2020 00:10:22

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.

Adam Wilson (POWER BI)'s profile image Profile Picture

Charles on 06 Jul 2020 00:09:12

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 ?

Adam Wilson (POWER BI)'s profile image Profile Picture

Data Analyst on 06 Jul 2020 00:08:33

RE: Increase Export Data Limits

Please match export limit to Excel limit.

Adam Wilson (POWER BI)'s profile image Profile Picture

Guus van Zuylen on 06 Jul 2020 00:05:39

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))

Adam Wilson (POWER BI)'s profile image Profile Picture

drg on 06 Jul 2020 00:05:37

RE: Increase Export Data Limits

3...years...later....

Adam Wilson (POWER BI)'s profile image Profile Picture

Jason Campbell on 06 Jul 2020 00:05:36

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?

Adam Wilson (POWER BI)'s profile image Profile Picture

Shane on 06 Jul 2020 00:04:48

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.

Adam Wilson (POWER BI)'s profile image Profile Picture

Tsogtb on 06 Jul 2020 00:04:37

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

Adam Wilson (POWER BI)'s profile image Profile Picture

Christos Christodoulou on 06 Jul 2020 00:04:31

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.