Forum Discussion
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!
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.
1 Reply
- foodd
Community Champion
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.