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

Diana Resendez on 05 Jul 2020 23:08:24

RE: Increase Export Data Limits

Need ability to export more rows of data. This is a basic need of many of our users and if a limitation like this exists, they will move to another tool.

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

Tom Stachura on 05 Jul 2020 23:08:12

RE: Increase Export Data Limits

I am hitting the limit with about 1700 records!

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

marnix jansen on 05 Jul 2020 23:08:11

RE: Increase Export Data Limits

Really need to export more then 150,000 rows because we need to be able to share outcome of analysis with people that do not use PowerBI. Major issue.

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

Colin Oglesbee on 05 Jul 2020 23:08:07

RE: Increase Export Data Limits

Please remove this limitation, in alignment with SSRS. My managers depend on the export capability to focus on quality improvement, and need to be able to export a very large number of rows.

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

Martin Hester on 05 Jul 2020 23:07:51

RE: Increase Export Data Limits

Please remove data export limitation. 150K lines is nothing. Or allow a .csv file, or something. Exporting 5 different files and then joining them up in my case is tiresome.

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

Power BI Ideas Admin on 05 Jul 2020 23:07:43

RE: Increase Export Data Limits

At the bare minimum let the PowerBI Admin role assign the limit online. Otherwise definitely remove the limit from PBI Desktop.

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

Power BI Ideas Admin on 05 Jul 2020 23:07:43

RE: Increase Export Data Limits

Please eliminate export limits!

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

Aoife on 05 Jul 2020 23:07:42

RE: Increase Export Data Limits

Finding it incredibly frustrating to constantly receive the "Your data is too large" error when trying to export. This really needs to be fixed, I cannot understand why Power BI desktop is unable to handle a simple export request.

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

Power BI User on 05 Jul 2020 23:07:05

RE: Increase Export Data Limits

It would be great if you can remove limits on exporting data.

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

Nimish Bhatnagar on 05 Jul 2020 23:07:03

RE: Increase Export Data Limits

Please get this sorted asap.