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

Bryan Kaiser on 08 Apr 2022 15:29:00

RE: Increase Export Data Limits

The limit needs to be removed on both Excel and especially CSV. Although there are workarounds (like the paginated report or Analyze in Excel), the limitation is arbitrary and should either be removed, or make it an admin setting that can be controlled by the organization.

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

John Orton on 19 Nov 2021 13:34:56

RE: Increase Export Data Limits

150000 seems random. Need more than this.

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

Karen Lillystone on 16 Nov 2021 09:25:51

RE: Increase Export Data Limits

Was wondering if there were updates on this? But I noticed that this does not seem to be showing in the Power BI Ideas list...

The business is reporting trouble with exporting data with the 150,000 rows - particularly even after filtering etc - the data is just over the limit - it is very frustrating

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

Chris Southall on 29 Sep 2021 13:04:49

RE: Increase Export Data Limits

As per all the comments below. Microsoft please sort this issue. It is a massive bottleneck and limitation of power bi.

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

Vahid Pournavab on 07 Sep 2021 08:55:49

RE: Increase Export Data Limits

This is such a massive bottleneck for Powerbi. I can't believe the dev team hasn't been able to figure out to allow more than 150k export by now.

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

Rachel S on 06 Jul 2021 17:16:59

RE: Increase Export Data Limits

this limit is ridiculous and creates a lot of non-value added work. Please increase ASAP.

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

Vahid Pournavab on 25 May 2021 01:01:26

RE: Increase Export Data Limits

Are there any plans to increase data export limit this year? Tableau doesn't have any export limitations, so it's very unfortunate to have this bottleneck in PowerBi. If performance impacts are the issue, then there should be an option for the developers to chose and adjust the data export functionality.

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

Tim Ozirsky on 16 Apr 2021 19:28:05

RE: Increase Export Data Limits

Tableau has no limitation on row export. Please remove the export limit of 150,000.

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

Timo Heideman on 29 Mar 2021 15:51:16

RE: Increase Export Data Limits

Please change/remove the rowlimit on exports from Power BI reports to csv -> unlimited and excel -> 1,048,576 (maybe -1 for the headers). End users need to be able to perform their own analysis / checks (for example in Excel) on the source data.

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

Sudharshan Kopperla on 07 Dec 2020 06:53:47

RE: Increase Export Data Limits

As other partners provided comments, even our Organization's users facing huge difficulty in performing this basic reporting operation due to its limitation. It was really frustating for the users to do the tedious work of getting export through drill-throughs/paginated reports/applying filters with multiple extracts. So requesting you to kindly look into this idea's implementation.

It's also not fair that idea won't be considered for implementation unless it reaches 2K limit. Atleast it should not be the case in providing the basic reporting functionalities. Hope this functionality will soon flow into Power BI. Also requesting the TAM to raise DCR with the filled Business Impact Document