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

Power BI User on 05 Jul 2020 23:48:59

RE: Increase Export Data Limits

Agree to have max row limit of excel.

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

Kurt Barajas on 05 Jul 2020 23:48:47

RE: Increase Export Data Limits

My company recently began using Power BI and the row limit continues to be a severe limitation. The data from visualizations and tables needs to exported for validation and to be sent to other parties.

I find myself taking many small chunks of data but as soon as we change part of our model, we have to go through the tedious task of re-exporting. Every single time.

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

Rolen Lo on 05 Jul 2020 23:48:14

RE: Increase Export Data Limits

How long do we need to wait further?

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

Power BI Ideas Admin on 05 Jul 2020 23:48:10

RE: Increase Export Data Limits

People will start losing confidence in this tool since raw data is limited to 150K and they cannot validate or do analysis properly.

Please can you increase the limit to match excel.

Thanks

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

Liam Newlin on 05 Jul 2020 23:47:37

RE: Increase Export Data Limits

Are there any updates related to removing the export limitation in Power BI Reporting Services? Will this be in the May, 2019 PBIRS Release?

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

Lee Haakenson on 05 Jul 2020 23:46:46

RE: Increase Export Data Limits

Definitely need to remove this limitation. We are evaluating multiple options, and this would definitely be a deal breaker for my organization.

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

Power BI User on 05 Jul 2020 23:46:38

RE: Increase Export Data Limits

definitely need no limit. drill downs are basically unusable unless you set a filter and then tie the data back together after exporting.

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

Power BI User on 05 Jul 2020 23:46:19

RE: Increase Export Data Limits

'+1 for increasing or removing the limit for Power BI Report Server.

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

Power BI User on 05 Jul 2020 23:44:50

RE: Increase Export Data Limits

It's been a year and admin promise to increase a year ago but nothing. meh.

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

Rafael Borghi on 05 Jul 2020 23:44:38

RE: Increase Export Data Limits

Also, it should allow to increase the export limit for Power BI Report Server (and not only to Power BI Service)