Cannot Export more than 200 rows

[mish2212]

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!

[foodd · Accepted solution]

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.

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]

Follow Gilbert Quevauvilliers post from June 2022 for general instructions.