Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

adamw1

Increase Export Data Limits

Submitted by on ‎02-23-2017 05:34 PM
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.
Status: Completed
See more ideas labeled with:
183 Comments (183 New)
Comments
llucchin
New Member
‎07-05-2020 03:58 PM
Increasing (or removing) this limit would certainly take our usage of power bi to the next level with the combination of the efforts from several of our teams. Excited to see increased integration of Power BI and R!
glog
New Member
‎07-05-2020 03:59 PM
1MM rows please
antonioarce
New Member
‎07-05-2020 03:59 PM
Definetively, improving export limits will become very useful when working with lots of data, since I need my team to action several reports for more than 150K lines. Totally love Power BI, but that is something Tableau can do and Power BI cannot.
martin72
New Member
‎07-05-2020 03:59 PM
This limit is a major blocker for using PowerBI with my Investment Banking client, many of their reports need to go out to customers in Excel format and can be up to 300k records, I presume this issue is related to limiting memory resources on the server? Can this not be overcome?
tlaw991
New Member
‎07-05-2020 03:59 PM
Major roadblock to convincing decision makers about the efficiency of using Power BI when compared to other platforms. Please remove this constraint --
jmorris1
New Member
‎07-05-2020 03:59 PM
We are really limited on rolling this out due solely to this issue. It is also odd that there is no warning (at least when exporting from a matrix). My data stopped around 38k rows (there was supposed to be 200k) and I only happened to notice because the totals were off.
gregor
Frequent Visitor
‎07-05-2020 04:00 PM
Removing the limit would be a huge step to give Power BI even more power and to become a stronger alternative to Tableau
douglas_j_verha
New Member
‎07-05-2020 04:00 PM
Definitely support a higher limit. Also, why can't I export to XLSX from a table when no aggregates are in the table?
ralf_simon
New Member
‎07-05-2020 04:01 PM
The export limit to 30k rows (or even 150k for Pro) disqualifies Power BI as a reporting tool. It will definitly not be introduced in our company.
DisregardedJunk
New Member
‎07-05-2020 04:02 PM
Maximum limit to export should match the max limit of Excel. If it fits in Excel is should be able to be exported, If it doesn't fit in your Excel then it is too much to export.