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: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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
NellyZhang
New Member
‎09-13-2023 01:51 AM

Any solution for this issue?

I need to export the data for my weekly dashboard use, but I can only get 300 rows 😞 

Appreciate it if MS can fix this problem ASAP.

NellyZhang
New Member
‎09-13-2023 02:01 AM

Hi @IrkenCR 

How to export as excel (.xlsx) file? I only have save as .csv option after click export......

 

Thanks.

Nelly

ArdaGonul
New Member
‎09-13-2023 06:42 AM

Hi everyone,

 

It was working fine on Monday, Today i faced this problem, only exports 300 rows.

 

Best regards

 

IrkenCR
Microsoft Employee
Microsoft Employee
‎09-13-2023 10:04 AM

Hi @NellyZhang,

 

Make sure you have the option enabled in your Fabric tenant settings :

 

IrkenCR_0-1694624559598.png

 

@ArdaGonul  I'm not aware if the issue is happening again, the fix was deployed already. I will let you know if I see new cases coming for the same issue, otherwise I suggest you to open a support ticket to track of the issue.

AvaHu
Regular Visitor
‎09-13-2023 10:29 AM

Same Issue today, but I could downloaded it yesterday, I sent my PBI desktop to my co-worker, he could dowloaded. I do not know why...

genna_rwsc
Frequent Visitor
‎09-13-2023 12:10 PM

This is still an issue at my org. 
Desktop Version: 2.121.644.0 64-bit (September 2023)

These forum posts indicate others are also newly experiencing this issue today. 

clearyvictori
New Member
‎09-13-2023 12:12 PM

I am having the same issue as well, and can't find the option to export the file as an xlsx file. I don't have access to Fabric. 

AvaHu
Regular Visitor
‎09-13-2023 01:18 PM

I found a tempting solution, hope it will help you
1. Select the table which you would download, "View"--"Performance analyzer"--"Start Recording"--"Refresh visuals"--Table--"Copy Query"

AvaHu_0-1694635654504.png

AvaHu_1-1694635893753.png

 

 


2. Go to Table View, Table tools--New table, past the code after "Table="

AvaHu_2-1694636018265.png

 


3.  In the Table code:
1). Delete "DEFINE"
2) Find "   TOPN(

            502,

" chang "502" to "5000000002"
3) Delete from "Order by" to end
4) Change "EVALUATE" to "Return"
4. Click this table and right click--copy table, paste to excel

Thank you.

cjmpetroleum
Frequent Visitor
‎09-13-2023 01:34 PM

Yes, exactly what @AvaHu has done works. Can also perform this using DaxStudio, but less than ideal to have to use these extra steps for such a basic process as exporting data from a table visual. My tenet settings for export to CSV and XLS are both enabled. Problem is manifesting on BPi desktop Version: 2.121.662.0 64-bit (September 2023).

I try to export a table visual with less than 20k rows and get a warning than sampling will occur: clearly below supposed limits. @IrkenCR : this is not fixed for me, and others so it would appear. Are you able to assist? I can share a copy of my project: msg me if you can help pls. TY!

CM

foodd
Super User
Super User
‎09-13-2023 02:47 PM

An easy workaround is to lean on DAX Studio for the export including from a Visual.

Idea Statuses