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

Doug Verhaalen on 05 Jul 2020 23:00:55

RE: Increase Export Data Limits

Definitely support a higher limit. Also, why can't I export to XLSX from a table when no aggregates are in the table?

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

Greg on 05 Jul 2020 23:00:29

RE: Increase Export Data Limits

Removing the limit would be a huge step to give Power BI even more power and to become a stronger alternative to Tableau

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

Power BI User on 05 Jul 2020 22:59:57

RE: Increase Export Data Limits

Major roadblock to convincing decision makers about the efficiency of using Power BI when compared to other platforms. Please remove this constraint --

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

Martin on 05 Jul 2020 22:59:53

RE: Increase Export Data Limits

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?

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

Jeffery Morris on 05 Jul 2020 22:59:25

RE: Increase Export Data Limits

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.

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

Antonio on 05 Jul 2020 22:59:02

RE: Increase Export Data Limits

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.

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

Power BI User on 05 Jul 2020 22:59:02

RE: Increase Export Data Limits

1MM rows please

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

Luis Lucchini on 05 Jul 2020 22:58:42

RE: Increase Export Data Limits

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!

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

Aaron on 05 Jul 2020 22:57:18

RE: Increase Export Data Limits

will these limits be extended to Power BI Reporting Services as well. And also in the Power BI SSRS executable?

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

Power BI Ideas Admin on 05 Jul 2020 22:57:00

RE: Increase Export Data Limits

The use of * programming with PBI would benefit greatly from increasing this limit to way higher numbers. 150.000 is a real constraint if you have to work with higher frequency data.