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

Art Allmon on 05 Jul 2020 23:44:31

RE: Increase Export Data Limits

My end users are barking about getting only partial data sets and having to download via multiple requests. Not a good thing. Excel can handle more than 150,000 lines per sheet. Please broaden the interface to allow for a higher number of records exported.

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

Marc Hilti on 05 Jul 2020 23:44:30

RE: Increase Export Data Limits

any update???????????

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

Vicky M on 05 Jul 2020 23:43:36

RE: Increase Export Data Limits

Hello
Please increase this limit.

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

Kalvis Vasks on 05 Jul 2020 23:42:47

RE: Increase Export Data Limits

Match the row limit from Excel

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

Chris Nguyen on 05 Jul 2020 23:42:40

RE: Increase Export Data Limits

Match the row limit from Excel

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

José Cabeda on 05 Jul 2020 23:42:18

RE: Increase Export Data Limits

Is there any update for an increase?

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

Steve Bedford on 05 Jul 2020 23:42:06

RE: Increase Export Data Limits

150K? I just exported 30K of a 48K row table. Why only 30K?

Regardless, exporting should be the whole table from Power BI.

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

Anonymous on 05 Jul 2020 23:40:38

RE: Increase Export Data Limits

Extremely odd this limitation, while spreading the usage of the tool.
End users complaining a lot about that limitation considering that Excel now can handle more than a million lines.

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

Stine on 05 Jul 2020 23:40:17

RE: Increase Export Data Limits

I hope there will be no limits!!! This is a crucial function for the users of the reports.

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

Power BI User on 05 Jul 2020 23:39:45

RE: Increase Export Data Limits

This is a deal breaker in terms of leadership buy-in if they cannot get to the raw data. We often need to do line by line auditing.