Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

TWolsten

Export only extracts 300 rows on Summarized Data, File Format .csv

Submitted by Advocate IV on ‎08-31-2023 02:06 AM

Hi there,

 

I have a noticed a recent issue where people are trying to use the export via the Summarized Data and the File Format .csv 

 

It says it has a limit of 30,000 rows but on any export it only retrieves the first 300?

 

Can this be investigated please?

Status: Delivered

This issue has been fixed. Please update Power BI Desktop to the latest version and re-export.

See more ideas labeled with:
76 Comments (76 New)
Comments
genna_rwsc
Frequent Visitor
‎09-15-2023 11:07 AM

To further clarify, because I've seen some mixed posts. 
This is STILL an issue for me with PBI Desktop Version: 2.121.644.0 64-bit (September 2023). 

When exporting data from a visual in Desktop only 300 rows maximum are included regardless of dataset row size included in visual. 

ozne99
Frequent Visitor
‎09-16-2023 06:24 PM

Desktop is still not allowing you to export more than 300 rows. The workaround of downloading the report and exporting the visual still does not work.

TetraNitz
New Member
‎09-18-2023 02:56 AM

Experiencing the same issue! Please fix it ASAP.

ArdaGonul
New Member
‎09-18-2023 03:04 AM

On the Internet version problem solved,

On the Desktop version still same problem, cant export more then 300 rows

KierenPorter
Frequent Visitor
‎09-18-2023 06:40 AM

well I'm "glad" I'm not the only one noticing this (for the first time today, last week was just fine) in Desktop (2.121.662.0) when attempting to right-click export a (filtered) 7 column table to .csv and only getting 300rows max.

 

would be really good to see a reply from the devs, better yet a fix, soon.

LaWfulN
New Member
‎09-18-2023 07:00 AM

Echoing everyone else's complaints. This is a critical functionality and needs to be fixed ASAP.

EMP
Advocate II
Advocate II
‎09-18-2023 08:03 AM

Adding my voice to the pack. Still can't export more than 300 rows from Desktop. 

rexxk923
Regular Visitor
‎09-18-2023 08:55 AM

Please fix this ASAP, this is critical for my organization operations and we cannot function without the ability to export more than 300 rows. 

stelladiprin
New Member
‎09-18-2023 03:05 PM

We are experiencing the same issue in our organization. Do you have an ETA for its resolution?

Cyrilbrd
Helper IV
Helper IV
‎09-18-2023 07:14 PM

Same issue.
Extraction possible via URL https://app.powerbi.com/ , data is extracted as Microsoft Excel Worksheet (.xlsx)
Extraction via PBD limited to 300 rows and CSV only.
Note: 30,000 rows is too low, some data are way beyond this size and may need to be extracted for some users.
Tableau seem not to limit the size of the extraction.

Idea Statuses