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)
RE: Increase Export Data Limits
PBI team any update on this. Can we expect in this near future
RE: Increase Export Data Limits
Why limit the export at all? Since we are merely dumping the table into a csv file, I can see no reason why the entire table (of any size) cannot be dumped to the csv. We often use PBI Desktop to mashup the data, then need to post-process it in some other software. Is there any legitimate reason why MS needs to limit the number of rows? If PBI can create a table with millions of rows, we certainly should be able to dump the full table to a csv.
RE: Increase Export Data Limits
I agree with other comments - this should be unlimited if at all possible, for live/direct query as well as other types of connection.
RE: Increase Export Data Limits
does it export 150,000 rows when using Direct Query? I'm trying to export around 40K rows but it only exports 20K+ rows and each time i export i get a different number.
RE: Increase Export Data Limits
I need to export more rows. There should not be a limit!
RE: Increase Export Data Limits
Why limits? I don't understand it.
RE: Increase Export Data Limits
no limits
RE: Increase Export Data Limits
Yes
RE: Increase Export Data Limits
Enable the summarized report to be exported to Excel.
RE: Increase Export Data Limits
I was really disappointed to discover this 30K row limit. Spending a day playing with Power BI Desktop I was starting to think it might be a useful tool. I wanted to use it to manipulate large datasets. But this limitation is a showstopper and there can not really be a valid technical reason for it!