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

Didier Terrien on 10 Sep 2020 12:19:54

RE: Increase Export Data Limits

Voted.
Meanwhile you may have a look at "Analyze in Excel" external tool from SQLBI. It removes the limit. In the future, it will allow to use Excel templates to setup a personalized export.

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

Abdullah Ally on 24 Jul 2020 14:31:08

RE: Increase Export Data Limits

Absolutely.

Currently have to use workarounds such as DAX Studio for csv, which handle exports flawlessly. Where as Power BI limit you to 30k rows for CSV as well as 150k rows for excel, which is on the same Microsoft Platform. Shocking to say the least.

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

Olalekan Otaoroju on 13 Jul 2020 10:01:29

RE: Increase Export Data Limits

I don't know the reason behind this export limit is, but whatever the reason is, it's makes the application so useless.
Tableau doesn't have any export limitation and even though POWER BI has several advantages over Tableau, this single limitation makes it near useless as we may have to re-evaluate the use of Power BI in my organization.

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

Ben Marshall on 11 Jul 2020 04:46:41

RE: Increase Export Data Limits

Many common operational needs exist for 150k+ row export for our Pricing and Finance teams.

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

D Reinman on 06 Jul 2020 00:16:16

RE: Increase Export Data Limits

This is a major limitation, which is causing us to reevaluate the use of PBI. All of our customers have "export underlying data" as a basic requirement. Tableau allows user-friendly crosstab exports of over 33 million cells (or 1 million records of a 33 column table). If you hope to compete with Tableau and retain business, this should be a top priority (instead of forcing our report builders and users to jump through additional hoops with drill-through and paginated reports).

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

pradeep on 06 Jul 2020 00:16:15

RE: Increase Export Data Limits

Microsoft - PLEASE ADDRESS THIS ASAP.

Alternative solutions are not feasible at all.

For Eg we evaluated Paginated Reports - very basic, It has its own limitations

Embedding Report in App to overcome this limit?? Seriously? Then what is the purpose of having one central portal. How many report should we embed?

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

Angelfish 42 on 06 Jul 2020 00:15:47

RE: Increase Export Data Limits

Have just found out there is a limit of 150,000 rows when exporting to excel? We are trying to switch reports from another reporting tool (not the reporting tool mentioned in a previous comment) which does not have this limit at all and exports to excel without any problems.

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

Samik Pal on 06 Jul 2020 00:14:57

RE: Increase Export Data Limits

Hello Power BI team. This 150,000 limit on row export is a deal breaker. The end users in my organisation are already complaining about this. We have accounting and GL level transaction dashbaord for our end users. For YTD data the exports are often more than >150k. Please guys work through it to allow more rows to be exported. I brought Power BI and replaced Tableau in my client account in my company. Power BI is far better than Tableau for million reasons except this limitation. Tableau has no limitation on row export. Please work through it and devise a solution ASAP.

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

Power BI User on 06 Jul 2020 00:14:24

RE: Increase Export Data Limits

Any updates on the progress with this?

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

Power BI User on 06 Jul 2020 00:12:27

RE: Increase Export Data Limits

Concur. FIX this... match the row limit of excel.