Skip to main content
Microsoft Idea

Power BI

Needs Votes

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

Vote (293) Share
's profile image

on 2019-01-10 01:20:01

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

Administrator on 9/25/2023 4:57:34 PM

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) Merged Idea (12)
Vote 17
K D's profile image

K D on 2021-03-09 16:58:27

Power BI

Extend row limit for data exports

Currently only csv export is allowed with a 30,000 row limit within the PBI desktop. Whenever I have to export a file with more than 30,000 rows I have to publish to the PBI server and export to excel with a 150,000 row limit (sometimes still not enough) or split my report into multiple segments ...

Merged
Vote 2
Vote 37
Engaged User's profile image

Engaged User on 2016-04-27 05:34:36

Power BI

Export PowerBI Desktop to CSV/Excel II (remove cap)

This is the continuation of the highly acclaimed "Export PowerBI Desktop to CSV/Excel". It is interesting how you can export from plenty of sources, but are locked up after you complete your analysis. Lets say recently I faced the challenge of cleaning a database with up to 2 million rows. Altho...

Merged
Vote 23
Warren Bell's profile image

Warren Bell on 2020-10-05 10:50:39

Power BI

Export of data to CSV > 30k rows

This has been around for a long while now. Still not resolved..... Need the ability to export more than 30,000 rows of data to csv, need a minimum 500k rows

Merged
Vote 1
HERVE MANCIO's profile image

HERVE MANCIO on 2021-01-29 15:33:26

Power BI

Exporter plus de 150 000 lignes sous Excel (ou au moins plus de 30 000 lignes en CSV)

Pour des besoins financiers, il est fréquent d'avoir des tables ou matrices de plus de 150 000 lignes. En partant d'un P&L par exemple on souhaiterait pouvoir exporter les mouvements comptables détaillés dans excel pour les retravailler. Or nous sommes limités à 150 000 lignes Excel et 30 000 CSV...

Merged
Vote 9
Stacey König's profile image

Stacey König on 2021-09-10 13:49:54

Power BI

Increase Export Limit for csv files

I am surprised that the export limit for csv files is limited to 30,000 rows. I can understand that the Excel downloads is limited due to size of files but it is my understanding that csv files are an efficient way to export/download large amounts of data for use in Power Pivot in Excel or Power ...

Merged
Vote 1
HERVE MANCIO's profile image

HERVE MANCIO on 2021-01-29 16:06:03

Power BI

Exporter plus de 150 000 lignes en Excel (ou au moins plus de 30 000 lignes en CSV)

Pour des besoins financiers, nous avons besoin d'exporter des mouvements comptables détaillés depuis un rapport de type P&L depuis le service Power BI. Ces mouvements pouvant être volumineux, serait il possible d'augmenter la limite de 150 000 lignes excel (ou au moins augmenter les 30 000 lignes...

Merged
Vote 15
Karthik Palaniswamy's profile image

Karthik Palaniswamy on 2021-03-26 19:37:27

Power BI

Export data tables as CSV/excel

Please make an option to export data tables as CSV/excel

Merged
Vote 24
Frank Shamash's profile image

Frank Shamash on 2022-10-24 15:44:54

Power BI

Export to CSV with greater than 30,000 rows

It will be important for us, and possibly for many others, if Power BI reports have the capability to export to CSV with more than the current limitation of 30,000 rows.This is especially helpful with the automation procedures that we are attempting to run, as they seem to prefer CSV da...

Merged
Vote 12
Hari Chandan Dadi's profile image

Hari Chandan Dadi on 2021-05-27 22:32:43

Power BI

Need to export data upto 500,000 rows

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.

Merged