Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

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.

Comments
sgallo
Advocate IV

@foodd I understand that I can use it but I have been sing PowerBI Desktop with my team and we are all up to speed to use that. I am hoping that Microsoft will fix it soon and avoid us learning how to use DAX studio. Thanks anyway for the input, I might start using it myself.

 

olszykn
Frequent Visitor

having the same issue. been telling our users to publish to the service and then export since they dont have dax studio. this is not ideal. 

SPa
Frequent Visitor

ETA on fix for Desktop version?

 

Relying on this for data export for crucial reporting. Please add the export functionality to the testing of the desktop version prior to release of a new version. 

 

Right now I am very screwed, as I don't have the ability to use the mitigation strategies outline in the thread. 

peter2002
New Member

Any update for the desktop? I can still only export 300 rows? I use this for reporting

foodd
Super User

@peter2002,  you can quite easily export your required data using DAX Studio quite easily without creating additional technical overhead or costs.

Onemig
Regular Visitor

Looks like the issue with export to csv in PBI service is now resolved. I can now download up to 30,000 rows as designed.

v-yetao1-msft
Community Support

Hi @TWolsten 

Please check the export function in PBI Service .

 

Best Regards,
Community Support Team _ Ailsa Tao

v-tangjie-msft
Community Support
Status changed to: Delivered

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

olszykn
Frequent Visitor

@v-tangjie-msft what is the newest version number? 

foodd
Super User

@olszykn ,

 

It appears to be fixed on the version of Power BI Desktop from the Microsoft Store.  Successfully exported 2134 rows as CSV.   Screenshots below:

 

foodd_0-1695821212382.png

foodd_1-1695821212437.png

foodd_0-1695821327036.png