Skip to main content

Power BI

Needs Votes

Please increase the export limit (30,000 rows csv or 150,000 rows excel) we need twice that.

Vote (303) Share
's profile image

on 10 Jan 2019 01:20:01

Please increase the export limit (30,000 rows csv or 150,000 rows excel) we need twice that.

Administrator on 25 Sep 2023 16:57:34

For those looking for larger exports please try the formatted table feature. See https://learn.microsoft.com/en-us/power-bi/paginated-reports/web-authoring/paginated-formatted-table

Comments (34)
's profile image Profile Picture

on 05 May 2022 23:02:22

RE: Please increase the export limit (30,000 rows csv or 150,000 rows excel) we need twice that.

There is limitation on number of rows to be exported for a report in power services which is 150,000 rows.
We need more rows to be exported, as there are many customer who want to export data up to 500,000 rows.

's profile image Profile Picture

Roger Pearson on 15 Dec 2021 17:46:29

RE: Please increase the export limit (30,000 rows csv or 150,000 rows excel) we need twice that.

Please make the number of rows that can be exported part of the client tool or service setting for a dataset.
This should be far higher than 150,000 at least 500,000 is more practical

's profile image Profile Picture

Ahmad Isnayuha on 12 Oct 2021 11:13:43

RE: Please increase the export limit (30,000 rows csv or 150,000 rows excel) we need twice that.

Just expand it to the excel limit, even using multiple sheet to accomodate more rows on export.

's profile image Profile Picture

Vahid Pournavab on 07 Sep 2021 08:59:00

RE: Please increase the export limit (30,000 rows csv or 150,000 rows excel) we need twice that.

There is also a PowerBI idea for this increase https://ideas.powerbi.com/ideas/idea/?ideaid=47820719-f315-48b1-b708-146c2d0e4db8&page=1

's profile image Profile Picture

Vahid Pournavab on 07 Sep 2021 08:58:38

RE: Please increase the export limit (30,000 rows csv or 150,000 rows excel) we need twice that.

There is also a PowerBI idea for this increase https://ideas.powerbi.com/ideas/idea/?ideaid=47820719-f315-48b1-b708-146c2d0e4db8&page=1

's profile image Profile Picture

Tejaswini Kaja Kaja on 02 Sep 2021 10:06:19

RE: Please increase the export limit (30,000 rows csv or 150,000 rows excel) we need twice that.

Please increase the export limit (30,000 rows csv or 150,000 rows excel). This feature request has been requested for a long time. Otherwise please provide any other alternative to download more data into the report.

's profile image Profile Picture

Tejaswini Kaja Kaja on 02 Sep 2021 10:03:12

RE: Please increase the export limit (30,000 rows csv or 150,000 rows excel) we need twice that.

Please increase the export limit (30,000 rows csv or 150,000 rows excel). While most of the other tools have no restriction in downloading the amount of data, restricting this feature is killing the potential of the tool. Please let this feature be implemented in near product release.

's profile image Profile Picture

Vahid Pournavab on 24 Jun 2021 05:32:19

RE: Please increase the export limit (30,000 rows csv or 150,000 rows excel) we need twice that.

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.

's profile image Profile Picture

Vahid Pournavab on 24 May 2021 05:48:30

RE: Please increase the export limit (30,000 rows csv or 150,000 rows excel) we need twice that.

Completely agreed! PowerBI Data export limit should be at least 1Mil. I can't believe this option is not yet available or more developers aren't asking for such capability. PowerBI team, as far as I am concerned, Tableau Desktop and Tableau Server do not have any enforced row or column limits for the amount of data that can be imported, why is there such a low data export limit in Powerbi?

's profile image Profile Picture

Karen Lillystone on 08 Dec 2020 11:29:54

RE: Please increase the export limit (30,000 rows csv or 150,000 rows excel) we need twice that.

There is also a PowerBI idea for this increase https://ideas.powerbi.com/ideas/idea/?ideaid=47820719-f315-48b1-b708-146c2d0e4db8&page=1

Merged Idea (12)