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

Reply
mish2212
New Member

Cannot Export more than 200 rows

I am not sure if a bug has been introduced with the new update, but I cannot export to excel from table visualizations more than 200 rows of data, which I previously was able to. I have September 2023 version of powerbi Desktop. Can someone let me know if it is something on my end or if this is a known issue? Thank you!

1 ACCEPTED SOLUTION
foodd
Super User
Super User

Hello @mish2212 , this is a known issue (Issue #498), and is Tagged as ACTIVE.

 

WHERE TO LEARN MORE:

You can follow Issues at:  Power BI known issues - Power BI | Microsoft Learn

 

ISSUE DESCRIPTION:

Issue ID:  498

Date:  September 7, 2023

Title:  Export to CSV file truncated at 300 rows

Description: When you select Export data on a tabular visual's options menu and choose to export to a CSV file, the resulting downloaded file is truncated to 300 rows, rather than showing all the available rows.

Status:  Active

Reference URL:  https://learn.microsoft.com/en-us/power-bi/troubleshoot/known-issues/known-issue-498-export-csv-file...

 

ADDITIONAL SUGGESTIONS:

If you wish to close this thread and add a reply to the Issue #498 thread, you will be automatically

notified when it is resolved.

 

ADDITIONAL WORKAROUND:  Use DAX Studio to export data from selected Visual to CSV or Excel.

Additionally, you may use DAX Studio to export any table or data from a visual quite easily:

Using Performance analyzer you are able to capture the DAX query behind the visual.  Copy the DAX query, and use this in DAX Studio to return the data behind the visual.  This is also quite handy when writing documentation.

 

foodd_0-1695152823266.png

 

 

 

In this case, the DAX expression would be :

 

 

// DAX Query used by Table Visual to return Gross Sales column data
DEFINE
    VAR __DS0Core =
        DISTINCT ( 'financials'[Gross Sales] )
    VAR __DS0PrimaryWindowed =
        TOPN ( 501, __DS0Core, 'financials'[Gross Sales], 1 )

EVALUATE
__DS0PrimaryWindowed
ORDER BY 'financials'[Gross Sales]

 

 

foodd_1-1695152823217.png

 

 

 

Follow Gilbert Quevauvilliers post from June 2022 for general instructions.

View solution in original post

1 REPLY 1
foodd
Super User
Super User

Hello @mish2212 , this is a known issue (Issue #498), and is Tagged as ACTIVE.

 

WHERE TO LEARN MORE:

You can follow Issues at:  Power BI known issues - Power BI | Microsoft Learn

 

ISSUE DESCRIPTION:

Issue ID:  498

Date:  September 7, 2023

Title:  Export to CSV file truncated at 300 rows

Description: When you select Export data on a tabular visual's options menu and choose to export to a CSV file, the resulting downloaded file is truncated to 300 rows, rather than showing all the available rows.

Status:  Active

Reference URL:  https://learn.microsoft.com/en-us/power-bi/troubleshoot/known-issues/known-issue-498-export-csv-file...

 

ADDITIONAL SUGGESTIONS:

If you wish to close this thread and add a reply to the Issue #498 thread, you will be automatically

notified when it is resolved.

 

ADDITIONAL WORKAROUND:  Use DAX Studio to export data from selected Visual to CSV or Excel.

Additionally, you may use DAX Studio to export any table or data from a visual quite easily:

Using Performance analyzer you are able to capture the DAX query behind the visual.  Copy the DAX query, and use this in DAX Studio to return the data behind the visual.  This is also quite handy when writing documentation.

 

foodd_0-1695152823266.png

 

 

 

In this case, the DAX expression would be :

 

 

// DAX Query used by Table Visual to return Gross Sales column data
DEFINE
    VAR __DS0Core =
        DISTINCT ( 'financials'[Gross Sales] )
    VAR __DS0PrimaryWindowed =
        TOPN ( 501, __DS0Core, 'financials'[Gross Sales], 1 )

EVALUATE
__DS0PrimaryWindowed
ORDER BY 'financials'[Gross Sales]

 

 

foodd_1-1695152823217.png

 

 

 

Follow Gilbert Quevauvilliers post from June 2022 for general instructions.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.